A
Adam Kroger
=SUMIF(C12:C24,"W",Y12:Y24)+SUMIF(C12:C24,"A",Y12:Y24)+SUMIF(C12:C24,"M",Y12:Y24)
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
=SUMPRODUCT((ISNUMBER(FIND({"W","A","M"},C12:C24))*(Y12:Y24)))
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
B
Biff
Hi!
Try this:
=SUMIF(C12:C24,{"W","A","M"},Y12:Y24)
Biff
Try this:
=SUMIF(C12:C24,{"W","A","M"},Y12:Y24)
Biff
B
Biff
Ooops!
Disregard my reply!
Biff
Disregard my reply!
Biff
Biff said:Hi!
Try this:
=SUMIF(C12:C24,{"W","A","M"},Y12:Y24)
Biff
B
Bob Phillips
No!
=SUMPRODUCT(SUMIF(C12:C24,{"W","A","M"},Y12:Y24))
<vbg>
Bob
=SUMPRODUCT(SUMIF(C12:C24,{"W","A","M"},Y12:Y24))
<vbg>
Bob
A
Adam Kroger
THanks
Bob Phillips said:No!
=SUMPRODUCT(SUMIF(C12:C24,{"W","A","M"},Y12:Y24))
<vbg>
Bob
D
David Billigmeier
You don't even need sumproduct, a simple sum will do the same:
=SUM(SUMIF(C12:C24,{"W","A","M"},Y12:Y24))
=SUM(SUMIF(C12:C24,{"W","A","M"},Y12:Y24))