Remember Me?

#1
May 17th 05, 06:17 PM
 Linda G. Posts: n/a
Using COUNTIF & compare 2 different #'s

I've got a worksheet that I need to capture info between 1000 & 1080 and then
have the number of times it appears in a specific range. The last formula I
tried to input =COUNTIF(G2:AG2,"=1000")-COUNTIF(G2:AG2,"<=1080") reflects
either 0 in my target cell or gives me an error. Any help someone could give
would be greatly appreciated. Plus, please don't get to techical, I'm a
newby. Thanks!

#2
May 17th 05, 06:26 PM
 Duke Carey Posts: n/a

Maybe

=COUNTIF(G2:AG2,"<=1080") -COUNTIF(G2:AG2,"<1000")

"Linda G." wrote:

I've got a worksheet that I need to capture info between 1000 & 1080 and then
have the number of times it appears in a specific range. The last formula I
tried to input =COUNTIF(G2:AG2,"=1000")-COUNTIF(G2:AG2,"<=1080") reflects
either 0 in my target cell or gives me an error. Any help someone could give
would be greatly appreciated. Plus, please don't get to techical, I'm a
newby. Thanks!

#3
May 18th 05, 07:14 PM
 lggallo Posts: n/a

I've tried this before but with 1000 first and then 1080 second. Plus, I
didn't leave a blank space between the 1st range and the next COUNTIF. I'm
going to try the formula below and see how it goes. Will let you know what
happens. Thanks! Linda G

"Duke Carey" wrote:

Maybe

=COUNTIF(G2:AG2,"<=1080") -COUNTIF(G2:AG2,"<1000")

"Linda G." wrote:

I've got a worksheet that I need to capture info between 1000 & 1080 and then
have the number of times it appears in a specific range. The last formula I
tried to input =COUNTIF(G2:AG2,"=1000")-COUNTIF(G2:AG2,"<=1080") reflects
either 0 in my target cell or gives me an error. Any help someone could give
would be greatly appreciated. Plus, please don't get to techical, I'm a
newby. Thanks!

#4
May 18th 05, 07:32 PM
 lggallo Posts: n/a

It worked GREAT!!! Many, many thanks! Linda G

"lggallo" wrote:

I've tried this before but with 1000 first and then 1080 second. Plus, I
didn't leave a blank space between the 1st range and the next COUNTIF. I'm
going to try the formula below and see how it goes. Will let you know what
happens. Thanks! Linda G

"Duke Carey" wrote:

Maybe

=COUNTIF(G2:AG2,"<=1080") -COUNTIF(G2:AG2,"<1000")

"Linda G." wrote:

I've got a worksheet that I need to capture info between 1000 & 1080 and then
have the number of times it appears in a specific range. The last formula I
tried to input =COUNTIF(G2:AG2,"=1000")-COUNTIF(G2:AG2,"<=1080") reflects
either 0 in my target cell or gives me an error. Any help someone could give
would be greatly appreciated. Plus, please don't get to techical, I'm a
newby. Thanks!

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post maxtrixx Excel Discussion (Misc queries) 5 March 31st 05 06:21 PM Dave Peterson Excel Discussion (Misc queries) 3 March 29th 05 12:36 AM JonnieP Excel Worksheet Functions 3 February 22nd 05 03:55 PM maswinney Excel Worksheet Functions 3 November 16th 04 12:06 AM Liz G Excel Worksheet Functions 2 November 2nd 04 12:20 AM

All times are GMT +1. The time now is 12:57 AM.