In Excel 2013 I want to calculate a percentage of a total amount of payments made in a date range. The date range would be pulled out of a payment ledger.

In Excel 2013 I want to calculate a percentage of a total amount of payments made in a date range.  The date range would be pulled out of a payment ledger.  I have the rules that need to be applied to the totals but I don't know how to write the formulas.
Sales-Bonus.xlsx
IT_DangerousAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Rgonzo1971Connect With a Mentor Commented:
Hi,

pls try

=SUMIF(A12:A26,"<"&DATE(2015;3;5),E12:E26)*0.05

and

=SUMIFS(E12:E26,A12:A26,"<="&DATE(2015;4;30),A12:A26,">="&DATE(2015;4;19))*0.1

Regards
Sales-BonusV1.xlsx
0
 
IT_DangerousAuthor Commented:
Thanks.  This helped seed the solution to many of my Excel challenges.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.