Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Ed
 
Posts: n/a
Default 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
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up 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
  #3   Report Post  
Posted to microsoft.public.excel.newusers
CLR
 
Posts: n/a
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I add a second criteria to the SUMIF or DSUM function? jlpwilley Excel Worksheet Functions 2 January 12th 06 05:44 PM
Getting Excel whilst using the sumif formula to search for part of a word Newbie81 Excel Discussion (Misc queries) 1 December 20th 05 02:56 PM
Does SUMIF in Excel, take multiple criteria input? Xray_Dave Excel Worksheet Functions 5 December 14th 05 10:32 PM
SUMIF in multiple columns based on other criteria in Excel? Scott Powell Excel Discussion (Misc queries) 9 April 13th 05 02:32 PM
How do I ask for multiple criteria when creating a "sumif" formul. Rachelle Excel Worksheet Functions 3 December 2nd 04 12:49 AM


All times are GMT +1. The time now is 08:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"