Sum If based on a 3rd condition ?
=SUMPRODUCT(--(Data!$C$2:$C$100=D2),--(Data!$E$2:$E100=1),Data!$G$2:$G$100)
note that you cannot use the whole column when you use SUMPRODUCT as an
array formula
Thus the C2:C100 etc
--
Regards,
Peo Sjoblom
"Steve" wrote in message
...
I have this formula that is totaling all the hours in the G colum if the
data
in the C column matches the criteria entered in cell D2.
=SUMIF(Data!$C:$C,$D$2,Data!G:G)
I would like to obtain the above results filtered as follows.
The E column has many 1s, 2s, or 3s in it.
What formula would produce, - the total hours meeting the above criterea
but also only when there is a 1 in the E column ?
Thanks,
Steve
|