I have the normal three sheet workbook open. I was wondering if on one page i fill (color) a certain cell and could have, on another page, a formula summing the number of cells that i've highlighted in a certain color?
It doesn't update the formula until I save the workbook. Any suggestions? This is my formula--=SUMIF('2004 CALENDAR'!A5:AE5,"X",'2004 CALENDAR'!A6:AE6). In other words, if I add an X, it won't change the sum unless I save it.