Forum Discussion
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 with the name Carolyn in the 1st comumn but I keep getting errors. I have fixed
the dumb ones but am unable to get the rest to give me a value I get a blank cell.
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)
3 Replies
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)PeterBartholomew1 Thanks for responding I finally figured out what was going on.
I had copied the SS from another book that had restrictions on it. All cleared up \\
Thanks to all of you.
Dean Davis What kind of errors? Please show some data and the formula used. Without that, it's difficult to help.
