**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:

- Select a cell where you want to display the result of the formula.
- 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". - 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)
```