Sumif using not equal to ""

[zicktechnology]

Hi can you guys help me out in here.
i want to find those who are not equal to a specific text.
the logic is something like this.

if C29:C641 is not equal to "Samsung" and C29:C641 to "Apple" and B29:B641 is not equal to "HP Care Pack" then
sum all its find whoa are not equal to the text i said in E29:E641.

[Moo the Dog]

Try this in any blank cell not within your specified ranges:

=SUMIFS (E29:E641, C29:C641,"<>Samsung", C29:C641,"<> Apple", B29:B641, "<> HP Care Pack")

- Moo

[FDibbins]

use the sumifS() function...

=sumifs(E29:E641,C29:C641,"<>Samsung",C29:C641,"Apple",B29:B641"<>HP Care Pack")

lol Moo there must be an echo in here again
i think the OP wanted = Apple though