HighTechTalks DotNet Forums  

COUNTIF WITH Absolute references

Go Back HighTechTalks DotNet Forums Dotnet Dotnet General Discussions COUNTIF WITH Absolute references

Dotnet General Discussions microsoft.public.dotnet.general


Discuss COUNTIF WITH Absolute references in the Dotnet General Discussions forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
GG
 
Posts: n/a

Default COUNTIF WITH Absolute references - 11-03-2007 , 08:55 PM





Pseudo code
Count if greater than value in a reference cell
Cell C3 would be:
=COUNTIF(A1:A8,">=$B$1")/8


Reply With Quote
  #2  
Old   
Stephany Young
 
Posts: n/a

Default Re: COUNTIF WITH Absolute references - 11-03-2007 , 09:23 PM





And your point is .... ?


"GG" <GG (AT) discussions (DOT) microsoft.com> wrote

Quote:
Pseudo code
Count if greater than value in a reference cell
Cell C3 would be:
=COUNTIF(A1:A8,">=$B$1")/8


Reply With Quote
  #3  
Old   
GG
 
Posts: n/a

Default Re: COUNTIF WITH Absolute references - 11-03-2007 , 09:49 PM


It's not working.
$B$1 never works
but an actual number works
=COUNTIF(A1:A8,">=0.02")/8

How can I use countif using an absolute references?

"Stephany Young" wrote:

Quote:
And your point is .... ?


"GG" <GG (AT) discussions (DOT) microsoft.com> wrote in message
news:2D0C3AE8-FA3A-4D16-9E16-9A9F81ABB57D (AT) microsoft (DOT) com...
Pseudo code
Count if greater than value in a reference cell
Cell C3 would be:
=COUNTIF(A1:A8,">=$B$1")/8

Reply With Quote
  #4  
Old   
richardjking@gmail.com
 
Posts: n/a

Default Re: COUNTIF WITH Absolute references - 11-21-2007 , 07:59 AM


On Nov 4, 1:49 am, GG <G... (AT) discussions (DOT) microsoft.com> wrote:
Quote:
It's not working.
$B$1 never works
but an actual number works
=COUNTIF(A1:A8,">=0.02")/8

How can I use countif using an absolute references?



"Stephany Young" wrote:
And your point is .... ?

"GG" <G... (AT) discussions (DOT) microsoft.com> wrote in message
news:2D0C3AE8-FA3A-4D16-9E16-9A9F81ABB57D (AT) microsoft (DOT) com...
Pseudo code
Count if greater than value in a reference cell
Cell C3 would be:
=COUNTIF(A1:A8,">=$B$1")/8- Hide quoted text -

- Show quoted text -
=COUNTIF(A1:A8,">="&$B$1)/8 does not come up with an error, but when I
tried this syntax it didn't give the right answer either.


Reply With Quote
  #5  
Old   
richardjking@gmail.com
 
Posts: n/a

Default Re: COUNTIF WITH Absolute references - 11-21-2007 , 08:40 AM


On Nov 21, 12:59 pm, richardjk... (AT) gmail (DOT) com wrote:
Quote:
On Nov 4, 1:49 am, GG <G... (AT) discussions (DOT) microsoft.com> wrote:





It's not working.
$B$1 never works
but an actual number works
=COUNTIF(A1:A8,">=0.02")/8

How can I use countif using an absolute references?

"Stephany Young" wrote:
And your point is .... ?

"GG" <G... (AT) discussions (DOT) microsoft.com> wrote in message
news:2D0C3AE8-FA3A-4D16-9E16-9A9F81ABB57D (AT) microsoft (DOT) com...
Pseudo code
Count if greater than value in a reference cell
Cell C3 would be:
=COUNTIF(A1:A8,">=$B$1")/8- Hide quoted text -

- Show quoted text -

=COUNTIF(A1:A8,">="&$B$1)/8 does not come up with an error, but when I
tried this syntax it didn't give the right answer either.- Hide quoted text -

- Show quoted text -
Just tried it again, and it did work, it just didn't update properly
the first time, maybe due to the large number of calculations in the
spreadsheet.


Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.


Contact Us - HighTechTalks DotNet Forums - Archive - Top