Dragging compound formula to multiple cells

[tara_922]

Hiya all!

Here's my formula

=IF(COUNTIF(G9:G1580,">=1"),"",COUNTIF(G9:G1580,G1432))

I obviously have this formula for all of 1580 cells and want to be able to select cell 1432 and drag down to 1580 keeping (G9:G1580) the same but adding one to G1432. Is this possible?

Thanks in advance,
Tara

 

[GlennUK]

What did your original formula do:

=IF(COUNTIF(G9:G1580,">=1"),"",COUNTIF(G9:G1580,G1432))

and what does this do:
=IF(COUNTIF($G$9:$G$1580,">=1"),"",COUNTIF($G$9:$G$1580,G1432))
... you seem to be saying that the results are now different ( when in fact no logical change has been done ).

 

[tara_922]

It doesn't seem to matter which code I use they still return blank when the value should be 2?! I'm lost on this. I'm thinking I'll just do a conditional format to highlight all cells 2 and above red.

Thanks,
Tara