Thread: sumif statement
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jackie
 
Posts: n/a
Default sumif statement

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