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

=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

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: