V
V. Marley
How can we write sumif on multiple criteria.
For instance, I have a list in A2:E100.
I want the sum of range E2:E100 if values in cell C2:C100
equals "N" and values in cell D2
100 equal value 3?
Once the above can work, I would like to parametrize the
formula; i.e. instead of the hard-coded values in the
formula (e.g. "N", 3, etc.) I would like to pick up the
values from cells F2, F3.
For instance, I have a list in A2:E100.
I want the sum of range E2:E100 if values in cell C2:C100
equals "N" and values in cell D2
100 equal value 3?Once the above can work, I would like to parametrize the
formula; i.e. instead of the hard-coded values in the
formula (e.g. "N", 3, etc.) I would like to pick up the
values from cells F2, F3.