Solved

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

Posted on 2015-01-22
65 Views
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
0
Question by:IT_Dangerous

LVL 48

Accepted Solution

Rgonzo1971 earned 500 total points
ID: 40565874
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

Author Closing Comment

ID: 40580560
Thanks.  This helped seed the solution to many of my Excel challenges.
0

## Featured Post

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…