I have been trying to figure out a formula to
compare column A to a cell and compare column B to another cell then SUM the value column C
ex:
A B C
DATE Operation tph
SAT 046-00 8.6
SUN 046-00 0
WED 047-00 7.6
THU 047-00 9.8
SAT 331-00 44.5
I tried
=SUM(IF($A$2:$A$2049=$G2,IF($B$2:$B$2049=$F4,1,0),0)) but this return the count, I need SUM of column C not a count .
compare column A to a cell and compare column B to another cell then SUM the value column C
ex:
A B C
DATE Operation tph
SAT 046-00 8.6
SUN 046-00 0
WED 047-00 7.6
THU 047-00 9.8
SAT 331-00 44.5
I tried
=SUM(IF($A$2:$A$2049=$G2,IF($B$2:$B$2049=$F4,1,0),0)) but this return the count, I need SUM of column C not a count .