OT excel experts. Need to know if this formula is possible

yes

what's the formula I would use

See if this helps

If you can program it, you can do it in excel.


The main limitation is that I know of no way to "save or store variables.

It is just what it is in the cell now in real time

You willing to use VBA?

Yes but it is a huge pain in the arse. Easier way to do it in my experience is to write the formula that created the colors into your formula

quote:

---

You willing to use VBA?

---

I'd imagine this is the way to go

can't do it that way. The highlighted cells are formulas. If you rearrange them then you'll lose the values.

You could always ghetto approach it, copy values not formulas to a new sheet and do what he says. Not pretty but can get the job done. You can sum referencing those values from the other sheet