or even
=AVERAGE(IF(OR(LEFT(A2:A640,2)="TU"),(LEFT(A2:A640 ,5)="ANA36")),B2:B640)
array entered.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Peo Sjoblom" wrote in message
...
If you meant either of TU or ANA36
=AVERAGE(IF((LEFT(A2:A640,2)="TU")+(LEFT(A2:A640,5 )="ANA36"),B2:B640))
also array entrered
--
Regards,
Peo Sjoblom
"Peo Sjoblom" wrote in message
...
=AVERAGE(IF(LEFT(A2:A640,2)="TU",B2:B640))
entered with ctrl + shift & enter
for TU
--
Regards,
Peo Sjoblom
"Darla" wrote in message
...
I need to average the cost per lb if a string starts with...my spread
sheet
is 640 rows long with over 10 averages needed.
I know how to do the formula except how to say "starts with" instead
of
"="
the string is quite long but I only need to reference the first part
of
it
"tu or ana36"
example below
TU SQRPR INB000160032000384000000200000000
ANA36 BAR INB000160001600002000000200000000
ANA36 BAR INB000160001600004000000200000000
|