SUMIF - Criteria of "><"

upobDaPlaya
upobDaPlaya used Ask the Experts™
on
I came across a SUMIF where it used "><" as the criteria.. Can you translate ?

=SUMIF(A1:A13,"><",B1:B13)
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solutions Only
Wayne Taylor (webtubbs)
Commented:
The ranges look a bit wonky. AG:A13 isn't a valid range.

But assuming this formula...

    =SUMIF(A6:A13,"><",B6:B13)

...it is summing the values in cell B6:B13 where the value in A6:A13 is equal to "><". In other words, it isn't doing anything special.
Michael FowlerSolutions Consultant
Commented:
In this case the value "><" is treated as a string value with no particular meaning. Therefore the formula will return the sum of the range B1:B13 if the range A1:A13 contains the string "><".

Reverse the brackets and you get not equal to "<>" but even then you still need a value eg

=SUMIF(A6:A13,"<>C1",B6:B13)

Open in new window


This sums the range B6:B13 if the values in A6:A13 does not contain the value in C1
Associate Principal Engineer
Top Expert 2014
Commented:
Hello,

Actually the formula is counting occurrence of "><" from range A1:A13 and giving sum of the value in the columnB against the same.

For example

A1 = "><" B1 = 2
A2 = "" B2 = 4
.
.
.
A13 = "><" B13 = 2

The result of the formula = 2 + 2 = 4
upobDaPlaya

Author

Commented:
Actually the criteria "><" indicates not null

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial