| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I count two variables in different columns in excel?
I am trying to count the number of data items in a given column given data
items in another column. Both data is in text format? |
|
#2
|
|||
|
|||
|
do you mean
=COUNTIF(A:A,B2) -- HTH Bob Phillips "Mad-z" wrote in message ... I am trying to count the number of data items in a given column given data items in another column. Both data is in text format? |
|
#3
|
|||
|
|||
|
Bob
Thanks for the timeous response - I am now using the pivot tables. Thakns once again for your willingness to help. Bye "Bob Phillips" wrote: do you mean =COUNTIF(A:A,B2) -- HTH Bob Phillips "Mad-z" wrote in message ... I am trying to count the number of data items in a given column given data items in another column. Both data is in text format? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count cells across muliple columns | Excel Worksheet Functions | |||
| Reduce columns and rows count? | Excel Worksheet Functions | |||
| Count on multiple columns | Excel Worksheet Functions | |||
| want to count in two columns; countif (colA=x AND colB=y)? | Excel Worksheet Functions | |||
| Count certain changes between columns | Excel Worksheet Functions | |||
Linear Mode
