The RANGE CRITERIA are in column B, C, D and E, rows 4-43.
The CRITERIA also in column B, C, D and E in row 52,
The SUM RANGE in column F, rows 4-43.
The SUMIFS works like a charm when all CRITERIA (B52, C52, D52, E52) are correctly populated. If however (i) one or more of the CRITERIA is not populated or (ii) is populated with a CRITERIA that doesnít match with any of the fields in the respective RANGE CRITERIA, the result is zero.
What I would like the formula to do is SUM, based on one, two, three or all four criteria.
To no avail, Iíve also tried to get the required result a SUMPRODUCT formula:
The SUMPRODUCT results are identical as with SUMIFS: works when all CRITERIA are correctly populated, donít deliver the required result when one, two, three or all four criteria arenít populated or doesnít match with any of the fields in the respective RANGE CRITERIA.
Can anyone help me?