Hello,

I'm quite new to excel, so this may be a basic question.
With my data, every 4 cells returns #VALUE!. This is fine and expected as there is nothing to divide by.
I'm in need of a formula that once i get #VALUE! will instead sum the three cells above.
So for instance cell T12 returns #VALUE!, and i then want the formula to sum T9, T10, and T11.
T16 returns #VALUE! and i want the formula to sum T13, T14, T15.

This is my first post so hopefully I was clear enough in my description, otherwise I'll do my best to clarify.