Okay, so what I'm dealing with is a progress claim form which has 12 tabs, each tab being 1 month.
The column i'm trying to make work is the "claim to date" where it will add the previous amounts claimed over the previous months.
I've made this work with this formula...
=IF(C8="","",(IF('2'!H8="",(IF('2'!G8="","",'2'!G8)),(IF('2'!H8="","",'2'!H8))+(IF('2'!J8="",0,'2'!J8)))))
Note - it's this complicated because I don't want it to say #VALUE! or $0.00 everywhere it was missing an input.
The problem with this formula is that once i get onto month 3 or 4 etc, if i have not entered a claim in say, month 1, it won't bring ANY of the claims forward.
Sorry if this is confusing anyone but I have been immersed in this for the past few days and I fear I am too deep to work out a working equation.
I will send the file i'm working on if anyone cares to look at it.
Thanks in advance if you can help
Bookmarks