Forum Discussion
Prob lem with SUMIF
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)
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.