Forum Discussion
Sumif
I have three columns: 1-Type 2-Work 3-Value I would like to sum column 3 with one condition from column 2 and multiple conditions from column 1. How would I do this?
=SUMPRODUCT(((A2:A16="A")+(A2:A16="E"))*(B2:B16="North")*C2:C16)
Please see attached worksheet.