=SUMPRODUCT(--(A2:A100=""def"),--(B2:B100="poer"),E2:E100)
it cannot work on whole columds, only ranges in a column.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"WTG" wrote in message
...
I have a worksheet as follows.
a b c d e
1 abc xyz 456
2 def poer 789
3 werq iug 123
4 kljh jklh 486
I need a sumif " if column a=def and b= poer then sum column e"
I tried the following formula, but it didn't work :(
=SUMIF(D_TICK!$a$1:$e$1000,('PIT & QUARRY'!F22)&('PIT &
QUARRY'!H18),D_TICK!$e$1:1000)
any ideas??
Wally
|