excel classes - Formulas

Hi Andrea

You can't easily use the sumif on its own for this.

i suggest you create another column with the AND function in it to test the condition you've set. Then use this column as the range for the SUMIF function

The syntax for the AND column would be (Inthe example you've given)

=AND(A1="DFD",B1="February")

I've enclosed a spreadsheet with the solution for youre information

Regards

Dear Andrea

I found this query to be quite interesting and have been looking at other possible easier way of solving this problem.

After some research I found that there is a feature called the Conditional Sum Wizard. It is normally in the Tools menu but if you cannot see it then most probably have to use Tools> Add In to install this feature.

Once you've got it installed you're in business.

It is very straight forward. Just follow these Steps:

Step 1: Click anywhere inside the list that you have.
Step 2: Choose Tools > Conditional Sum...
Step 3: It would have selected the entire table so just click Next button
Step 4:
- In this step please ensure that Amount is the Column to Sum.
- Below where you have to put the condition, simply choose the Company from the drop down list
- Choose DFD from the This Value drop down list
- Click the Add Condition button
- Repeat the above for your Month column
- Click the Next Button
Step 5: You can leave the first option "Copy just the formula to a single cell" option. Click the next button
Step 6: Click in the white box and Select the cell where you'd like the result to be displayed

This will give you the desired result.

The good this is that if you do change any data in the future in any of the columns the result will update itself.

Hope this helps.

Kindest Regards

Rajeev
MOS Master Instructor