Is there an easier way to do this, SUMIF() question
 

=SUMIF(C12:C24,"W",Y12:Y24)+SUMIF(C12:C24,"A",Y12: Y24)+SUMIF(C12:C24,"M",Y12:Y24)

Is there an easier way to do this, SUMIF() question
 

=SUMPRODUCT((ISNUMBER(FIND({"W","A","M"},C12:C24)) *(Y12:Y24)))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message
. ..

=SUMIF(C12:C24,"W",Y12:Y24)+SUMIF(C12:C24,"A",Y12: Y24)+SUMIF(C12:C24,"M",Y12
:Y24)

Is there an easier way to do this, SUMIF() question
 

Hi!

Try this:

=SUMIF(C12:C24,{"W","A","M"},Y12:Y24)

Biff

"Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message
. ..
=SUMIF(C12:C24,"W",Y12:Y24)+SUMIF(C12:C24,"A",Y12: Y24)+SUMIF(C12:C24,"M",Y12:Y24)

Is there an easier way to do this, SUMIF() question
 

Ooops!

Disregard my reply!

Biff

"Biff" wrote in message
...
Hi!

Try this:

=SUMIF(C12:C24,{"W","A","M"},Y12:Y24)

Biff

"Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message
. ..
=SUMIF(C12:C24,"W",Y12:Y24)+SUMIF(C12:C24,"A",Y12: Y24)+SUMIF(C12:C24,"M",Y12:Y24)

Is there an easier way to do this, SUMIF() question
 

No!

=SUMPRODUCT(SUMIF(C12:C24,{"W","A","M"},Y12:Y24))

<vbg

Bob

"Biff" wrote in message
...
Ooops!

Disregard my reply!

Biff

"Biff" wrote in message
...
Hi!

Try this:

=SUMIF(C12:C24,{"W","A","M"},Y12:Y24)

Biff

"Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message
. ..

=SUMIF(C12:C24,"W",Y12:Y24)+SUMIF(C12:C24,"A",Y12: Y24)+SUMIF(C12:C24,"M",Y12
:Y24)

Is there an easier way to do this, SUMIF() question
 

THanks


"Bob Phillips" wrote in message
...
No!

=SUMPRODUCT(SUMIF(C12:C24,{"W","A","M"},Y12:Y24))

<vbg

Bob

"Biff" wrote in message
...
Ooops!

Disregard my reply!

Biff

"Biff" wrote in message
...
Hi!

Try this:

=SUMIF(C12:C24,{"W","A","M"},Y12:Y24)

Biff

"Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message
. ..

=SUMIF(C12:C24,"W",Y12:Y24)+SUMIF(C12:C24,"A",Y12: Y24)+SUMIF(C12:C24,"M",Y12
:Y24)

Is there an easier way to do this, SUMIF() question
 

You don't even need sumproduct, a simple sum will do the same:

=SUM(SUMIF(C12:C24,{"W","A","M"},Y12:Y24))

--
Regards,
Dave


"Bob Phillips" wrote:

No!

=SUMPRODUCT(SUMIF(C12:C24,{"W","A","M"},Y12:Y24))

<vbg

Bob

"Biff" wrote in message
...
Ooops!

Disregard my reply!

Biff

"Biff" wrote in message
...
Hi!

Try this:

=SUMIF(C12:C24,{"W","A","M"},Y12:Y24)

Biff

"Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message
. ..

=SUMIF(C12:C24,"W",Y12:Y24)+SUMIF(C12:C24,"A",Y12: Y24)+SUMIF(C12:C24,"M",Y12
:Y24)