Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
COUNTIF criteria
Hi,
I have some large data tables and want to make COUNTIF formulas to return the number of datapoints above, below etc certain values. I would like to make the formula "interactive" so I dont have to create a new formula for each criteria. I would like to enter the value in a certain cell which is then used as criteria in the formula. Does anybody know how to do that ? Thanx, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
COUNTIF criteria
Thanx,
but this doesn't work when I want to add ,< or = in front of the cell reference. (I guess only the value from the cell should be retrieved). Is there a fix for this ? Thanx again. -----Original Message----- Is this a code question...sounds like a simple sheet function.. =COUNTIF(MySource,D4) This counts the number of items in the range named MySource that match the value of the item in cell D4 Patrick Molloy Microsoft Excel MVP -----Original Message----- Hi, I have some large data tables and want to make COUNTIF formulas to return the number of datapoints above, below etc certain values. I would like to make the formula "interactive" so I dont have to create a new formula for each criteria. I would like to enter the value in a certain cell which is then used as criteria in the formula. Does anybody know how to do that ? Thanx, . . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
COUNTIF criteria
Thanx a lot - works perfectly!
-----Original Message----- If you want to add the criteria in the formula, try using this: =COUNTIF(MySource,"<"&D4) Ecco -----Original Message----- Thanx, but this doesn't work when I want to add ,< or = in front of the cell reference. (I guess only the value from the cell should be retrieved). Is there a fix for this ? Thanx again. -----Original Message----- Is this a code question...sounds like a simple sheet function.. =COUNTIF(MySource,D4) This counts the number of items in the range named MySource that match the value of the item in cell D4 Patrick Molloy Microsoft Excel MVP -----Original Message----- Hi, I have some large data tables and want to make COUNTIF formulas to return the number of datapoints above, below etc certain values. I would like to make the formula "interactive" so I dont have to create a new formula for each criteria. I would like to enter the value in a certain cell which is then used as criteria in the formula. Does anybody know how to do that ? Thanx, . . . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif for more than one criteria | Excel Worksheet Functions | |||
countif but have two criteria | New Users to Excel | |||
Criteria for Countif | Excel Worksheet Functions | |||
Countif using format criteria not number criteria? | Excel Worksheet Functions | |||
Countif using format criteria....not number criteria? | Excel Worksheet Functions |