Forum home » Delegate support and help forum » Microsoft Excel Training and help » Sum If/And
|
|
|
The UK's most regular 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. |
Sum If/And
Resolved · Medium Priority · Version 2007
Reply 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!
For upcoming training course dates see: Pricing & availability
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
Reply 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
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
Reply 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
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
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.
|