SOLVED

# Prob lem with SUMIF

Copper Contributor

# 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.

3 Replies

# Re: Prob lem with SUMIF

@Dean Davis What kind of errors? Please show some data and the formula used. Without that, it's difficult to help.

best response confirmed by Dean Davis (Copper Contributor)
Solution

# Re: 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)
= SUMIF(range, criteria, sum_range)``````

# Re: Prob lem with SUMIF

@Peter Bartholomew 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.

1 best response

Accepted Solutions
best response confirmed by Dean Davis (Copper Contributor)
Solution

# Re: 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)