Unable to calculate year to date score

leonv01

New Member
Joined
Mar 31, 2011
Messages
6
Looking for a formula to calculate YTD score. I'm using this formula: =YTDPntsAvail(LEFT($A$1,4),M15,R15,X15,AC15,AH15,AN15,AS15,AY15,BD15,BI15,BO15,BT15,NOW()) But receive #REF! error back...

YTD Points Available should be calculated by adding points available for all months prior to current month. For example, if the BSC update is occurring in March, YTD Points Available = January Points Available + February Points Available.

Hope somebody can help me on this issue!
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Watch MrExcel Video

Forum statistics

Threads
1,108,787
Messages
5,524,877
Members
409,609
Latest member
Channingz

This Week's Hot Topics

Top