View Single Post
  #2   Report Post  
Duke Carey
 
Posts: n/a
Default

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!