| 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"? |
| 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 | |||
Threaded Mode
