To sum column C using two criteria - dates in column A and text "Rent" in column B, you can use the

**SUMIFS** formula. Here are the steps to follow:

- Select an empty cell where you want to display the result.
- Type the following formula:

Formula:

```
``````
=SUMIFS(C:C,A:A,"="&DATE(2007,12,1),A:A,"<="&DATE(2008,1,31),B:B,"Rent")
```

- Press Enter.

Explanation:

The

**SUMIFS** formula allows you to sum values based on multiple criteria. In this case, we want to sum values in column C based on two criteria:

- Dates in column A that are greater than or equal to 12/1/2007 and less than or equal to 1/31/2008.

- Text "Rent" in column B.

The first argument of the formula (

**C:C**) is the range of values that we want to sum.

The second argument (

**A:A,"="&DATE(2007,12,1),A:A,"<="&DATE(2008,1,31)**) specifies the criteria for dates in column A. We use the

**=** and

**<=** operators to include all dates between 12/1/2007 and 1/31/2008. The

**&** symbol is used to concatenate the operators and the

**DATE** function that creates a date value.

The third argument (

**B:B,"Rent"**) specifies the criteria for text in column B. We simply use "Rent" as the text value.

The formula will return the sum of all values in column C that meet both criteria. In this example, it will return

**$1,000.00**.