sumproduct

[Guest]

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"))

 

[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"}))