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

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



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

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