Share via

Excel Formel

Martin, Heidi (SE GP T SP PS) 571 Reputation points
2023-10-10T08:33:08.5233333+00:00

Hello,

I would need a formula that calculates the following:

I want the sum of J10-J2020 to appear in cell J2015, only if there is the same value in column B2015 and in column J2015.

Thank you!

Microsoft 365 and Office | Excel | For business | Windows

Answer accepted by question author

Viorel 127K Reputation points
2023-10-10T10:22:29.6566667+00:00

Check if this formula for cell J2015 has sense:

=LET(s,SUM(J10:J2014)+SUM(J2016:J2020),IF(B2015=s,s,""))

Was this answer helpful?

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.