software

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

try using quotes for text and NOT for numbers.

=SUMPRODUCT((L7:L2589=quot;fquot;)*(L7:L2589=quot;FBquot;)*(L7:L25 89=quot;EBquot;))
--
Don Guillett
SalesAid Software

quot;Robquot; gt; wrote in message
...
gt;I am trying to sum with 3 criteria but not as complicated as in different
gt; row. I tried this formula but it doesn't seem to work. I want to sum if
gt; the
gt; column equals, f,eb, fb.l The would be or so I asking sum all cells that
gt; have an f eb fb.
gt;
gt; =SUMPRODUCTR((L7:L2589=f)*(L7:L2589=FB)*(L7:L2589= EB))
gt; Please help

It doesn't look like you're summing anything. Are you just trying to
count cells in your range equal To quot;Fquot;, quot;EBquot; or quot;FBquot;? If so

=SUM(COUNTIF(L7:L2589,{quot;Fquot;,quot;FBquot;,quot;EBquot;}))

...or

=SUMPRODUCT(--(L7:L2589={quot;Fquot;,quot;FBquot;,quot;EBquot;}))--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=508771