# using sum if and not equal to??

This is a discussion on using sum if and not equal to?? within the Excel Questions forums, part of the Question Forums category; Hello, I'm wondering can you use sumif so that excel sum's a group of values with the conditional that your ...

1. ## using sum if and not equal to??

Hello,

I'm wondering can you use sumif so that excel sum's a group of values with the conditional that your range is not equal to a certain value? I want to sum all values in column B based on the numbers in column A that are all not equal to 5.

is this possible?

2. ## Re: using sum if and not equal to??

Hello,

I'm wondering can you use sumif so that excel sum's a group of values with the conditional that your range is not equal to a certain value? I want to sum all values in column B based on the numbers in column A that are all not equal to 5.

is this possible?
=SUMIF(A:A,"<>5",B:B)

3. ## Re: using sum if and not equal to??

Hello,

Do you mean like this?

=SUMIF(A1:A5,"<>5",B1:B5)

where
A1:A5 and B1:B5 = 1 to 5

4. ## Re: using sum if and not equal to??

I was missing the " "

"thanks"

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•