Forum Discussion
Solved
Prob lem with SUMIF
I feel bad having to ask this question because I have used it in the past 10 years ago I have a column with names in the next column I have amounts. I want to sum the total of the amounts ...
Wow, I haven't seen SUMIF for years!
If I were tasked with the challenge of creating a blank cell, I would ensure there are no matches and then adopt a number format that displays a blank cell for zero. Either by a hidden character or maybe by entering the arguments in the wrong order.
= SUMIF(sum_range, range, criteria) "instead of" = SUMIF(range, criteria, sum_range)
Dean Davis What kind of errors? Please show some data and the formula used. Without that, it's difficult to help.