sumproduct
 

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

sumproduct
 

try using quotes for text and NOT for numbers.

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



--
Don Guillett
SalesAid Software

"Rob" wrote in message
...
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

sumproduct
 

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=508771