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 Otten


"Jerome" <(E-Mail Removed)> wrote in message
news:7D52852E-6425-46DD-A1C7-(E-Mail Removed)...
>

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!
=====================================================

"Jerome" <(E-Mail Removed)> wrote in message
news:7D52852E-6425-46DD-A1C7-(E-Mail Removed)...

"Niek Otten" wrote:

> 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 Otten
>
>
> "Jerome" <(E-Mail Removed)> wrote in message
> news:7D52852E-6425-46DD-A1C7-(E-Mail Removed)...
> >
>
>
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