Perhaps it was something like:

=IF(AR$3=1,AT4,0)+IF(AR$3=2,AT4+AV4,0)+IF(AR$3=3,A T4+AV4+AX4,0)+...........)

An alternative could be:

=CHOOSE(AR$3,AT4,AT4+AV4,AT4+AV4+AX4,AT4+AV4+AX4+A Z4,AT4+AV4+AX4+AZ4+BB4,
AT4+AV4+AX4+AZ4+BB4+BD4,AT4+AV4+AX4+AZ4+BB4+BD4+BB F4,AT4+AV4+AX4+AZ4+BB4
+BD4+BF4+BH4,AT4+AV4+AX4+AZ4+BB4+BD4+BF4+BH4+BJ4,A T4+AV4+AX4+AZ4+BB4+BD4+
BF4+BH4+BJ4+BL4,AT4+AV4+AX4+AZ4+BB4+BD4+BF4+BH4+BJ 4+BL4+BN4,AT4+AV4+AX4+
AZ4+BB4+BD4+BF4+BH4+BJ4+BL4+BN4+BO4)

This chooses from the number in AR3 either:
AT4
AT4+AV4
AT4+AV4+AX4
AT4+AV4+AX4+AZ4
etc

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Blessedx3" wrote in message
...
Awhile back, I came here and found a formula for an IF statement that had
more than 7 IFs. I put it into my spreadsheet and it worked
perfectly...well
I saved over it and now it's gone :(

I hope someone here can get me the correct formula again. Here is my
problem:
cell AR3 contains the month (1 for July, 2 for August, etc) and changes
each
month. Cells BR4:BR19 contain year-to-date totals for our 16 water
systems
from the prior year. The IF statement was something like =IF(AR$3<=1,
AT4),
IF(AR$3<=2, AT4+AV4), IF(AR$3<=3, AT4+AV4+AX4), etc...

Obviously, this isn't correct because it doesn't work...LOL! I need
column
BR to only add January when AR3=1, add January + February when AR3=2, add
January + February + March when AR3=3, etc.

Clear as mud, right? If anyone can help, I will be so very grateful!!!

THANKS!!!