Hello users!
I want to make summing with multiple criteria and one criteria cell is may be blank or string. I tried sumif, sumproduct and if functions but i culdn't. For example for criteria range 1 is column A2:A17, for criteria range 2 is column B2:B17, for criteria range 3 is column C2:C17, and for summing range is D2:D17. Criteria cell for range 1 is F3 and criteria cell for range 2 is G2 and criteria cell for range 3 is H3. Criteria cell H3 is may be string or blank. H3 cell depending on the situation it can be blank or not blank. But if H3 is blank total is wrong or returning 0. How can i handle it.
I want to make summing with multiple criteria and one criteria cell is may be blank or string. I tried sumif, sumproduct and if functions but i culdn't. For example for criteria range 1 is column A2:A17, for criteria range 2 is column B2:B17, for criteria range 3 is column C2:C17, and for summing range is D2:D17. Criteria cell for range 1 is F3 and criteria cell for range 2 is G2 and criteria cell for range 3 is H3. Criteria cell H3 is may be string or blank. H3 cell depending on the situation it can be blank or not blank. But if H3 is blank total is wrong or returning 0. How can i handle it.