software

Hi Jerome,

What should the cell be if A2 not =1?

Let's say zero. To be able to sum, don't use quotes, it will make the cell
text instead of number,so it can not be summed.

=IF(A2=1,90,0)

--
Kind regards,

Niek Ottenquot;Jeromequot; gt; wrote in message
...
gt;
Is this what you're looking for:

=SUMPRODUCT((A2:A30=1)*90)
OR
=COUNTIF(A2:A30,1)*90

?
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

quot;Jeromequot; gt; wrote in message
...


quot;Niek Ottenquot; wrote:

gt; Hi Jerome,
gt;
gt; What should the cell be if A2 not =1?
gt;
gt; Let's say zero. To be able to sum, don't use quotes, it will make the cell
gt; text instead of number,so it can not be summed.
gt;
gt; =IF(A2=1,90,0)
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt;
gt; quot;Jeromequot; gt; wrote in message
gt; ...
gt; gt;
gt;
gt;
ok what i have 46 diff (=if ) in 8 diff cell now im trying to add them all
up. i could send you the file so you can see what it look like