I am use (=IF(A2=1,"90") in a few cell i need to then add them up

N

Niek Otten

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)
 
R

RagDyeR

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

news:[email protected]...
 
J

Jerome

Niek Otten said:
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)
Click to expand...
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
 
Top