| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
need help with formula
I have a range of cell I want to count ,,say the 2's but with this formula
,,,,=SUMPRODUCT(--(ISNUMBER(FIND("2",G18:G41)))) I count not only the 2's by them selfs but also the 2's in 22 or 12 etc..giving me the wrong results... Also I want to count the 2's only if this range of cells,,,,, N18:O41 has 4A entered into it... can some one help. slow hand |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
need help with formula
=COUNTIF(G18:G41,2)
=SUMPRODUCT(--(G18:G41=2),--((N18:N41="4A")+(O18:O41="4A"))) -- HTH Bob Phillips "slow hand" wrote in message ... I have a range of cell I want to count ,,say the 2's but with this formula ,,,,=SUMPRODUCT(--(ISNUMBER(FIND("2",G18:G41)))) I count not only the 2's by them selfs but also the 2's in 22 or 12 etc..giving me the wrong results... Also I want to count the 2's only if this range of cells,,,,, N18:O41 has 4A entered into it... can some one help. slow hand |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
need help with formula
Thanks Bob works great
slow hand "Bob Phillips" wrote: =COUNTIF(G18:G41,2) =SUMPRODUCT(--(G18:G41=2),--((N18:N41="4A")+(O18:O41="4A"))) -- HTH Bob Phillips "slow hand" wrote in message ... I have a range of cell I want to count ,,say the 2's but with this formula ,,,,=SUMPRODUCT(--(ISNUMBER(FIND("2",G18:G41)))) I count not only the 2's by them selfs but also the 2's in 22 or 12 etc..giving me the wrong results... Also I want to count the 2's only if this range of cells,,,,, N18:O41 has 4A entered into it... can some one help. slow hand |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
need help with formula
My pleasure.
Bob "slow hand" wrote in message ... Thanks Bob works great slow hand "Bob Phillips" wrote: =COUNTIF(G18:G41,2) =SUMPRODUCT(--(G18:G41=2),--((N18:N41="4A")+(O18:O41="4A"))) -- HTH Bob Phillips "slow hand" wrote in message ... I have a range of cell I want to count ,,say the 2's but with this formula ,,,,=SUMPRODUCT(--(ISNUMBER(FIND("2",G18:G41)))) I count not only the 2's by them selfs but also the 2's in 22 or 12 etc..giving me the wrong results... Also I want to count the 2's only if this range of cells,,,,, N18:O41 has 4A entered into it... can some one help. slow hand |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Commenting custom formula fields/formula on formula editor | Excel Programming | |||
Hybrid Mode
