steve manos
New Member
- Joined
- Mar 15, 2013
- Messages
- 2
Howdy Folks!
I'm young to Excel, using XL 2010 with Windows 7, and was wondering if
there's a formula solution using COUNT and SUM in combination?
I used a helper column to get the answer to:
How many days does it take, before I clear $500 dollars?
The answer is 7.
I'd rather construct a simple formula though at the bottom of Column B ($/day)
to Count the number of rows, therfore days, until I reach my Sum value of $500.
Thanks,
Stevie!
<TBODY>
</TBODY>
I'm young to Excel, using XL 2010 with Windows 7, and was wondering if
there's a formula solution using COUNT and SUM in combination?
I used a helper column to get the answer to:
How many days does it take, before I clear $500 dollars?
The answer is 7.
I'd rather construct a simple formula though at the bottom of Column B ($/day)
to Count the number of rows, therfore days, until I reach my Sum value of $500.
Thanks,
Stevie!
Work day | $/day | helper column? |
1 | 61.21 | 61.21 |
2 | 81.90 | 143.11 |
3 | 83.66 | 226.77 |
4 | 70.83 | 297.60 |
5 | 91.28 | 388.88 |
6 | 87.06 | 475.94 |
7 | 74.73 | 550.67 |
8 | 82.34 | 633.01 |
9 | 85.11 | 718.12 |
<TBODY>
</TBODY>