 # Sumif - Sum a range based on a single cell

• Hi

I got a problem with my "sumif formula". I think it is very simple to fix, but I can't find a solution to it.

I want to sum a range of cells, if a single cell got the specific initials.

=sumif(M9;"IS";N9:Q9), For some reason this formula does only give the value from cell N9, and not the range, N9:Q9.

I'm sorry for bad english, but I hope you will understand me.

• Re: Sumif - Sum a range based on a single cell

Sumif is probably the wrong tool for this, you're better off with just IF and SUM; [f]=if(M9="IS",sum(N9:Q9),0)[/f] You don't say what you want to return if M9 doesn't pass the test, so I've set it to 0.

• Re: Sumif - Sum a range based on a single cell

The problem with your formula is that the range int he first agument is not the same size and the range in the last arguement: they must be equal in size.
The excel Help is a very good resource for understanding the syntax and required arguements for functions.

Example:
=SUMIF(A1:A10,"IS",B1:B10)

That being said, based on your formula and as pointed out by LocalPeople, SUMIF doesn't seem to be the correct function.
Provide more detail if the solution offered is not what you need.

[COLOR="blue"][SIZE="4"][FONT="Verdana"]AAE[/FONT][/SIZE][/COLOR]
[COLOR="blue"]----------------------------------------------------[/COLOR]

• Re: Sumif - Sum a range based on a single cell

Worked perfectly when i divided the formula into IF and SUM.

Thank you so much guys!

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!