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
[email protected]
"Rob" <[email protected]> wrote in message
news:[email protected]...
>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"}))