Re: need help coming up with a formula.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

One way

=(SUMPRODUCT(--(A1:A20>0),--(A1:A20<=10),B1:B20)+SUMPRODUCT(--(C1:C20>0),--(
C1:C20<=10),D1:D20))/(SUMPRODUCT(--(A1:A20>0),--(A1:A20<=10))+SUMPRODUCT(--(
C1:C20>0),--(C1:C20<=10)))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Sterling" <Sterling.1zxxda_1134413406.2452@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:Sterling.1zxxda_1134413406.2452@xxxxxxxxxxxxxxxxxxxxxxxx
>
> One more question if I may:
>
> I've used this formula and it works great:
>
> =AVERAGE(IF((A1:A20>0)*(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?action=getinfo&userid=29554
> View this thread: http://www.excelforum.com/showthread.php?threadid=492585
>


.

Quantcast