Remember Me?

Posted to microsoft.public.excel.newusers
 Ed Posts: n/a how to sumif in excel with a not equal criteria

Hi I'm trying to use the sumif function but I want to sum everything in a
range that is not equal to one criteria eg apples 10 orange 10 pear 10 ..
sum everything that is not equal to apple should return 20. Thank you
 ExcelBanter AI Excel Super Guru Posts: 1,867 Answer: how to sumif in excel with a not equal criteria

Hi there! To sum everything in a range that is not equal to a certain criteria, you can use the SUMIF function with the "<" operator. Here are the steps to do it:
1. Select a cell where you want to display the result of the formula.
2. Type the following formula:
Formula:
``` =SUMIF(range,"<apple",sum_range)  ```
- Replace "range" with the range of cells that contains the criteria you want to exclude (in this case, "apple").
- Replace "sum_range" with the range of cells that you want to sum (in this case, "10", "10", and "10").
- Note that the "<" operator means "not equal to".
3. Press Enter to calculate the formula.

For example, if your data is in cells A1:C1, and you want to sum everything that is not equal to "apple", you can use the following formula:
Formula:
``` =SUMIF(A1:C1,"<apple",A2:C2)  ```
__________________
I am not human. I am an Excel Wizard
Posted to microsoft.public.excel.newusers
 CLR Posts: n/a how to sumif in excel with a not equal criteria

=SUMIF(A:A,"<apples",B:B)

Vaya con Dios,
Chuck, CABGx3

"Ed" wrote in message
...
Hi I'm trying to use the sumif function but I want to sum everything in a
range that is not equal to one criteria eg apples 10 orange 10 pear 10 ..
sum everything that is not equal to apple should return 20. Thank you

 Thread Tools Search this Thread Show Printable Version Search this Thread: Advanced Search Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On Similar Threads Thread Thread Starter Forum Replies Last Post jlpwilley Excel Worksheet Functions 2 January 12th 06 04:44 PM Newbie81 Excel Discussion (Misc queries) 1 December 20th 05 01:56 PM Xray_Dave Excel Worksheet Functions 5 December 14th 05 09:32 PM Scott Powell Excel Discussion (Misc queries) 9 April 13th 05 02:32 PM Rachelle Excel Worksheet Functions 3 December 1st 04 11:49 PM

All times are GMT +1. The time now is 03:38 PM. Copyright ©2004-2023 ExcelBanter.