98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Sum If/And
Sum If/And
Resolved · Medium Priority · Version 2007
Fri 18 Feb 2011, 17:30Delegate Emma said...
Emma has attended:
Excel Advanced course
Sum If/And
Hello
I am trying to sum a column only if two criteria are met.
I have 100 rows of data and want to know if any of them are owned by person x and evaluated at risk Y to add them all up and return the total amount in the 100 rows.
Does that make sense???
Thank you!
Mon 21 Feb 2011, 19:19Trainer Nafeesa said...
RE: Sum If/And
Hi Emma
Thank you for your question, it makes perfect sense :)
If you can send me your email address I'll send you through an Excel file with an example and explanation of how the SUMIF function works.
Regards,
Nafeesa
Microsoft Office Specialist Trainer
Tue 22 Feb 2011, 10:59Delegate Emma said...
RE: Sum If/And
Nafeesa,
Please could you email me on levett.emma@gmail.com
Thank you
Fri 25 Feb 2011, 09:22Trainer Nafeesa said...
RE: Sum If/And
Hi Emma,
I'm training today, however will have something with you by the weekend.
Sorry for the delay.
Regards,
Nafeesa
Microsoft Office Specialist Trainer
Mon 28 Feb 2011, 10:36Delegate Emma said...
RE: Sum If/And
Nafeesa,
Im not sure but i think that due to some of the columns now having conditional formatting that the sumif function is not working - as the formula prior to this formatting was working...
Emma
Wed 2 Mar 2011, 11:44Trainer Nafeesa said...
RE: Sum If/And
Hi Emma,
The conditional formatting shouldn't affect the calculation.
I have just sent you an email with an example of a slightly different method of using the SUMIF function using an Excel add-in called Conditional Sum.
I hope this helps. Do let me know how it goes.
Regards,
Nafeesa
Microsoft Office Specialist Trainer
Wed 2 Mar 2011, 11:45Trainer Nafeesa said...
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
Wed 9 Mar 2011: Automatically marked as resolved.
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:Autofit column width – Excel (all versions)a. Highlight the column or columns you wish to alter the width of. You do this by clicking on the grey button at the top of the column showing the column letter. Click and drag on these letters to select more than one column. |
