close
I need a statment to look like:
=IF(B3:B33=N127,COUNTIF(Sheet1!CE4:CE9,3)/L3,0)But I get #Value!
I am assuming I need a sumproduct?? Can someone help with this formula?
D.
do you mean
=IF(COUNTIF(B3:B33,N127)gt;0,COUNTIF(Sheet1!CE4:CE9, 3)/L3,0)
--
HTH
Bob Phillips
(remove nothere from the email address if mailing direct)
quot;Daniellequot; gt; wrote in message
...
gt; I need a statment to look like:
gt;
gt; =IF(B3:B33=N127,COUNTIF(Sheet1!CE4:CE9,3)/L3,0)
gt;
gt;
gt; But I get #Value!
gt;
gt; I am assuming I need a sumproduct?? Can someone help with this formula?
gt;
gt; D.
全站熱搜
留言列表
