98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel classes - Formulas
excel classes - Formulas
Resolved · Low Priority · Version Standard
Andrea has attended:
Excel Advanced course
Formulas
How do I do a 'sum if' formula with more than one argument?
For example I have a list of data:
Company,Month,Amount
DFD, January,
RE: 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
Attached files...
RE: formulas
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Conditional Formatting in Excel 2010If you have lots of data in a spreadsheet, you may find that it is easier to read if you highlight some of the values. This is Conditional Formatting and here's how to use it: |