Maybe this...This is driving my crazy!
I want to subtract A1 from B1 only if there is a value displayed in both cells (note there is a formula in both cells). If there is not a value displayed in both A1 and B1 then I want the display in C1 to be blank. I keep getting a display of 0 in C1 and its messing up my average.
I've tried sumif with isblank but i think isblank doesn't work in this case because although the display looks blank there is a formula in both.