One way
=(SUMPRODUCT(--(A1:A200),--(A1:A20<=10),B1:B20)+SUMPRODUCT(--(C1:C200),--(
C1:C20<=10),D1:D20))/(SUMPRODUCT(--(A1:A200),--(A1:A20<=10))+SUMPRODUCT(--(
C1:C200),--(C1:C20<=10)))
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Sterling" wrote in
message ...
One more question if I may:
I've used this formula and it works great:
=AVERAGE(IF((A1:A200)*(A1:A20<=10),B1:B20))
Now, how do I incorporate a second set of data say in columns C and D.
For example, the first set of data, as I posted, would be for cars and
the second set would be for trucks. Using the above formula I can find
out the average cost for 0-10 day cars and 0-10 day trucks. How would I
set up the formula to come up with 0-10 day -vehicles-?
TIA again.
--
Sterling
------------------------------------------------------------------------
Sterling's Profile:
http://www.excelforum.com/member.php...o&userid=29554
View this thread: http://www.excelforum.com/showthread...hreadid=492585