Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count total balance using two numbers
This may be a little confusing, please bear with me.
I need to calculate a total balance, using a column of service dates. The price per date is the same. This is simple. Problem is, since July 2009 I need to use a different rate, while retaining the pre-July rate as well in the total. So is there a way to get a total balance for a column of dates with two different multipliers? I was using a simple COUNTA formula for the total number of dates and then just multiplying that number by my amount. I'm thinking to combine two counting formulas, one looking for pre-July 2009 dates and multiplying those by the old price and the second looking for the post-July 2009 dates and multiplying them by the new price. But I haven't been able to come up with this yet... Any help is appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need a total count for various numbers in a column | Excel Worksheet Functions | |||
How to display running-down numbers with total count? | Excel Worksheet Functions | |||
Find the balance of amount from a total count of 60.... | Charts and Charting in Excel | |||
How do i count numbers and letters to find a total count of all | Excel Worksheet Functions | |||
Count and Sum Total occurrances of two specific numbers | Excel Worksheet Functions |