| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTA?
I'm trying to put together a formula that will count the number of times the
data in cell D2 appears in column G. Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNTA?
=COUNTIF(G:G,D2)
-- __________________________________ HTH Bob "Paul" wrote in message ... I'm trying to put together a formula that will count the number of times the data in cell D2 appears in column G. Thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNTA?
Try this:
=COUNTIF(G:G,D2) Hope this helps. Pete On Jan 13, 4:11*pm, Paul wrote: I'm trying to put together a formula that will count the number of times the data in cell D2 appears in column G. Thanks! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNTA?
That worked perfectly!
Thanks so much!! "Bob Phillips" wrote: =COUNTIF(G:G,D2) -- __________________________________ HTH Bob "Paul" wrote in message ... I'm trying to put together a formula that will count the number of times the data in cell D2 appears in column G. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counta | Excel Worksheet Functions | |||
| Counta | Excel Worksheet Functions | |||
| COUNTA | Excel Worksheet Functions | |||
| COUNTA AND | Excel Discussion (Misc queries) | |||
| COUNTA Function not working =COUNTA(C3:C69,"NH") | Excel Worksheet Functions | |||
Linear Mode
