Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am begging for your help again ...
I would like to add another if statement to the following statement but keep getting errors so obviously I am missing something: =sumif(e2:e10,"1",g2:g10)and if(h2:h10,"1") Basically what I am trying to do is sum a column g2:g10 only if both of the other columns are 1. I will also be changing it to e is 1 & h is 2 .... any ideas? .... -- Jackie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sumif statement | Excel Discussion (Misc queries) | |||
Nested SumIf statement | Excel Worksheet Functions | |||
my sumif statement brings back mutiple answers, how do I fix it? | Excel Worksheet Functions | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
sumif statement | Excel Worksheet Functions |