Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

averageif cell doesn't contain "text"

950 views
Skip to first unread message

dkte737

unread,
Jul 18, 2012, 12:57:03 AM7/18/12
to

Hello, I have some data below I want to average but only if Column B
does not have "DAL". I had =averageif(b:b,<>"DAL",J:J) but it doesn't
like it. Any help?

Column B
CPS
CPS
CPS
DAL
GVT
DAL
MRY
DAL



Column J
435
783
0
276
0
1792
200
276




--
dkte737

Claus Busch

unread,
Jul 18, 2012, 3:47:35 AM7/18/12
to
Hi,

Am Wed, 18 Jul 2012 04:57:03 +0000 schrieb dkte737:

> Hello, I have some data below I want to average but only if Column B
> does not have "DAL". I had =averageif(b:b,<>"DAL",J:J) but it doesn't
> like it. Any help?

try:
=AVERAGEIF(B:B,"<>DAL",J:J)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

dkte737

unread,
Jul 18, 2012, 8:43:37 AM7/18/12
to

Spencer101;1603740 Wrote:
> Hi, try moving the first quote mark to before the <> rather than after
> it.
>
> =averageif(b:b,"<>DAL",J:J)

Thank you!

Now I realized to get a good weighted average, I need to multiply J:J by
its price in H:H, then take the average, but how do I do that?



Column B
Location
CPS
CPS
CPS
DAL
GVT
DAL
MRY
DAL
PHX


Column H
Fuel Purchased
435
783
0
276
0
1792
200
276
300


Column J
Fuel Price



4.21

4.34
6.34

4.24




--
dkte737
0 new messages