Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif formula
Excel 2002
=COUNTIF(Data,"*9*") This will return the number of cells in the range named Data that contain a 9. How can I make this formula refer to a cell instead of using the desired number in the formula. Say I have a drop down list in G1, if I select 4 then the formula should return the number of cells in Data that have a 4 in them. These do not work: =COUNTIF(Data,"*Mud*") Where G1 is a named cell Mud. =COUNTIF(Data,"*G1*") =COUNTIF(Data,"*INDIRECT(G1)*") Thanks Howard |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif formula
=COUNTIF(Data,"*" & A1 & "*")
-- Regards Dave Hawley www.ozgrid.com "L. Howard Kittle" wrote in message ... Excel 2002 =COUNTIF(Data,"*9*") This will return the number of cells in the range named Data that contain a 9. How can I make this formula refer to a cell instead of using the desired number in the formula. Say I have a drop down list in G1, if I select 4 then the formula should return the number of cells in Data that have a 4 in them. These do not work: =COUNTIF(Data,"*Mud*") Where G1 is a named cell Mud. =COUNTIF(Data,"*G1*") =COUNTIF(Data,"*INDIRECT(G1)*") Thanks Howard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif formula
Thanks Dave, I was struggling with this one.
Regards, Howard "L. Howard Kittle" wrote in message ... Excel 2002 =COUNTIF(Data,"*9*") This will return the number of cells in the range named Data that contain a 9. How can I make this formula refer to a cell instead of using the desired number in the formula. Say I have a drop down list in G1, if I select 4 then the formula should return the number of cells in Data that have a 4 in them. These do not work: =COUNTIF(Data,"*Mud*") Where G1 is a named cell Mud. =COUNTIF(Data,"*G1*") =COUNTIF(Data,"*INDIRECT(G1)*") Thanks Howard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF FORMULA ISSUES - NEED FORMULA CORRECTED | Excel Worksheet Functions | |||
Countif formula | Excel Discussion (Misc queries) | |||
help in countif formula. | Excel Discussion (Misc queries) | |||
CountIf formula results in the formula itself being displayed. | Excel Worksheet Functions | |||
Another Countif Formula | Excel Discussion (Misc queries) |