sumproduct

[Rob]

I am trying to sum with 3 criteria but not as complicated as in different
row. I tried this formula but it doesn't seem to work. I want to sum if the
column equals, f,eb, fb.l The would be or so I asking sum all cells that
have an f+eb+fb.

=SUMPRODUCTR((L7:L2589=f)*(L7:L2589=FB)*(L7:L2589=EB))
Please help

[Don Guillett]

try using quotes for text and NOT for numbers.

=SUMPRODUCT((L7:L2589="f")*(L7:L2589="FB")*(L7:L2589="EB"))



--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Rob" <Rob@discussions.microsoft.com> wrote in message
news:E4C87BCC-EE09-42A2-A88C-F560E7A3C36B@microsoft.com...
>I am trying to sum with 3 criteria but not as complicated as in different
> row. I tried this formula but it doesn't seem to work. I want to sum if
> the
> column equals, f,eb, fb.l The would be or so I asking sum all cells that
> have an f+eb+fb.
>
> =SUMPRODUCTR((L7:L2589=f)*(L7:L2589=FB)*(L7:L2589=EB))
> Please help

[daddylonglegs]

It doesn't look like you're summing anything. Are you just trying to count cells in your range equal To "F", "EB" or "FB"? If so

=SUM(COUNTIF(L7:L2589,{"F","FB","EB"}))

...or

=SUMPRODUCT(--(L7:L2589={"F","FB","EB"}))