Dragging compound formula to multiple cells

T

tara_922

Board Regular
Joined
Jul 15, 2011
Messages
127
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
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
Sort by date Sort by votes
Use absolute references...

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


Hope that helpps.
 
Upvote 0
=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
 
Upvote 0
That formula cannot be the one that you are using .... the parentheses do not even match to make a valid formula.
 
Upvote 0
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
 
Upvote 0
Start simple ... what happens with:

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

?
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question Question
Excel chart with a line that will adjust certain cells
Replies
0
Views
301
jondavis1987
J
R
  • Solved
Character count on each line within one cell
3 4 5
Replies
40
Views
783
Peter_SSs
Peter_SSs
Keebler
  • Solved
excel function from another cell
Replies
6
Views
149
smozgur
smozgur
FatalLordes
  • Solved
Create list from multiple cells on multiple sheets?
2
Replies
13
Views
247
Peter_SSs
Peter_SSs
J
  • Solved
Creating a formula while isolating one part of the information in a row
Replies
1
Views
241
steve the fish
steve the fish

Forum statistics

Threads
1,224,613
Messages
6,179,896
Members
452,948
Latest member
Dupuhini

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top