I cannot find anywhere the solution to this question.
s 1 500
q 1 100
w 2 50
e 2 24
s 3 80
I want to know the sum of column C where column A = s and Column B = 1
It is easy for one criteria, such as
=SUMIF(a1:a6,"s",c1:c6)
But i want to know how to write if col A=s and col b = 1 then what is the sum of col C
Please please please help.... I'm losing my mind.
Thanks
Bookmarks