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

 

[Jonmo1]

Use absolute references...

=IF(COUNTIF(G$9:G$1580,">=1"),"",COUNTIF(G$9:G$1580,G1432))


Hope that helpps.

 

[tara_922]

Awesome! I'm learning so much!

Tara

 

[tara_922]

=IF(COUNTIF(G$9:G$1580,"<=1,"",COUNTIF(G$9:G$1580,G1432))

This is still returning values =1

What oh what am I doing wrong??

Somebody please help!

Thanks
Tara

 

[GlennUK]

That formula cannot be the one that you are using .... the parentheses do not even match to make a valid formula.

 

[tara_922]

I'm sorry, my mistake...

=IF(COUNT(H$9:H$1580,"1"),"",COUNT(H$9:H$1580,H9))
I've tried count, count if, ="1" =">2"

just frustrated now.

thanks for your help

Tara

 

[GlennUK]

Start simple ... what happens with:

=COUNTIF(H$9:H$1580,H9)

?

 

[tara_922]

When I use that formula it returns a value of 1. I also tried it on a cell that i know has two or more values and it returned 2.

Thanks for helping with this. I'll try to reply quicker next time.

Tara

 

[GlennUK]

Glad to help.

 

[tara_922]

So how do I go from simple to eliminating anything less than 2 or less than or equal to 1?

The formula I am using, works to ignore the 0's and 1's but does not calculate anything whatsoever, just leaves everything blank...

Tara