The SUM function in Excel itself doesn't directly work with logical operators (AND, OR) within the formula. However, you can achieve similar functionality using a combination of approaches:

1. Nested IF statements:

This method involves nesting IF statements within the SUM function. You can create conditions using logical operators (AND, OR) to check if multiple criteria are met and then sum the values based on those conditions.

Example:

You have data on sales reps (Rep), regions (Region), and sales amounts (Amount). You want to sum the sales amounts for Rep "John" in the "East" region.

Formula:

```excel
=SUM(IF((A2:A10="John")*(B2:B10="East"),C2:C10,0))
```

Explanation:

- A2:A10 refers to the range containing Rep names.
- B2:B10 refers to the range containing regions.
- C2:C10 refers to the range containing sales amounts.
- The nested IF statement checks two conditions:
- Rep name in the current row (A2:A10) equals "John" (first AND)
- Region in the current row (B2:B10) equals "East" (second AND)
- If both conditions are met (TRUE), the corresponding sales amount from C2:C10 is added to the sum.
- If either condition is not met (FALSE), 0 is added (effectively ignoring that value).

2. SUMIFS function (Excel 2016 and later):

This function is specifically designed to handle multiple criteria for summing data. It simplifies the process compared to nested IF statements.

Example:

Using the same scenario as before (sum sales amounts for Rep "John" in the "East" region):

Formula:

```excel
=SUMIFS(C2:C10,A2:A10,"John",B2:B10,"East")
```

Explanation:

- C2:C10 - range containing sales amounts (sum output)
- A2:A10 - range containing Rep names (first criteria)
- "John" - value to match in Rep names (first criteria)
- B2:B10 - range containing regions (second criteria)
- "East" - value to match in regions (second criteria)

3. SUMPRODUCT function (advanced users):

This function can be used for more complex scenarios involving logical operators and arrays. It's less intuitive for beginners but offers more flexibility.

Remember: Choose the method that best suits your needs and Excel version. Nested IF statements offer more control but can be cumbersome for complex criteria. SUMIFS is a good balance between ease of use and functionality (available in newer versions). SUMPRODUCT is for advanced users comfortable with array manipulation.