what formula for summing if two logical statements are true?

S

steve95959

I am trying to automatically sum numbers in a spreadsheet according to person
and project task - so what formula do I use to sum #s with if two logical
statements are true, e.g, if d16:d60 = "Kelly" and e16:e60 = "tasks 1.5"?
 
D

Dave

Hi,
Try
=IF(AND(D16:D60 = "Kelly", E16:E60 = "tasks 1.5"),SUM(YourRange),"")
Change YourRange for the cells you want to Sum.
Regards - Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Logical value in time formula? 4
Logical test in IF statement returning incorrect result 3
Excell - two conditions count if factors are true when negative nu 2
Nested IF statements using AND / OR 2
Formula nesting with IF statements 2
Array formula and multiplying conditions 6
SUMIF, 3D FORMULA, EXCEL FORMULA HELP 1
IF and THEN statements 5

Top