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!
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
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
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.
