not sure if this is exactly what you want

in col G

=IF(AND(E1="1",H1="1"),"1","")

then add up the totals in col G



"Jackie" wrote:

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