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
Excell - two conditions count if factors are true when negative nu 2
Logical test in IF statement returning incorrect result 3
Nested IF statements using AND / OR 2
Need a proper guru! My head hurts ;( 1
Help with IF statements comparing more than two fields 2
MATCH/IF/OR/AND statements not what I need apparently 1
IF AND - need help with formula 10

Top