I have a set of data in Sheet1 with 3 columns...A,B,C. I'm trying to SUM the column C if A1:A10="CATEGORY" (or the cell that represents that category) AND if B1:B10="8" (or the cell...).
Right now, all I know how to do is the SUMIF for one of those conditions:
=SUMIF(Sheet1!$A$1:$A$10,$B$12,Sheet1!$C$1:$C$10)
How would I go about adding the 2nd condition? I've tried SUMPRODUCT and a couple of others. No dice. Thanks ahead of time!
Right now, all I know how to do is the SUMIF for one of those conditions:
=SUMIF(Sheet1!$A$1:$A$10,$B$12,Sheet1!$C$1:$C$10)
How would I go about adding the 2nd condition? I've tried SUMPRODUCT and a couple of others. No dice. Thanks ahead of time!