Excel formulas really aren't my forte and I suspect the answer will be straightforward
- foggy head bit too much beer on a school night!
I have a list of revenues that I am trying to break down into the number of discrete items.
Each item is generally one of 3 prices - 13.00,14.10,15.00 (there may be others, but these are the majority so I'm not concerned with other amounts)
I'm using the formula
Which gives the following results:
Account Revenue |
Total Items |
14.1 |
1 |
14.1 |
1 |
26 |
2 |
14.1 |
1 |
14.1 |
1 |
28.2 |
2 |
13 |
1 |
14.1 |
1 |
14.1 |
1 |
14.1 |
1 |
42.3 |
2.82 |
84.6 |
5.64 |
The last two lines are not the expected results - should be 3 and 6 respectively. I understand that this is to do with the way that the numbers are stored by excel, but I'm not sure how to adapt the formula to one that will work.
I've attached a workbook of the sample if anyone wants it.
Thanks for your help
Bookmarks