| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what formula for summing if two logical statements are true?
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"? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
what formula for summing if two logical statements are true?
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 "steve95959" wrote: 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"? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
what formula for summing if two logical statements are true?
=SUMPRODUCT(--(D16:D60="Kelly"),--(E16:E60="tasks 1.5"),SumRange)
"steve95959" wrote: 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"? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Logical Format showing 0/1 and not True/False. | Excel Discussion (Misc queries) | |||
| =IF(logical test,value if true,value if false) always backwards! | Excel Worksheet Functions | |||
| Intervals as logical statements | Excel Worksheet Functions | |||
| Logical ELSE statements | Excel Discussion (Misc queries) | |||
| Want to change the color of a true/false logical statement with i. | Excel Worksheet Functions | |||
Linear Mode
