That works just fine...while I was messing around with it myself, I
found that =SUM(IF((A50:A3000TODAY()-90)*(L50:L30000),H50:H3000))
also works...any ideas on which formula works "best"? They both find
the same answer, but I will be using various forms of the formula in
over 70 cells which are updated constantly when I add in a new flight.
I found that the
=SUM(IF((A50:A3000TODAY()-90)*(L50:L30000),H50:H3000)) formula causes
a slight slow down (recalculating the sheet takes about .5 seconds,
before adding in the new formulas it was immediate) when entering a new
flight.
--
qflyer
------------------------------------------------------------------------
qflyer's Profile:
http://www.excelforum.com/member.php...o&userid=24448
View this thread:
http://www.excelforum.com/showthread...hreadid=380762