using sum if and not equal to??

[admiral_Tristan]

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?

 

[just_jon]

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)

 

[onlyadrafter]

Hello,

Do you mean like this?

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

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

Giving an answer of 10.

 

[admiral_Tristan]

I was missing the " "

"thanks"