Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please help with Count or Countif...
Hi all. I did try searching this group for answers, but couldn't find
an example for exactly what I'm trying to do, although I'm sure it is quite simple (I'm and excel rookie...). Two columns, A & B: 1 n 1 a 1 2 2 c 2 1 1 y How do I do a count of how many rows have the "2" (text, not number) in column A -and- have non-blank in column B (so any text value in column B)? So in the above case, I would want the result to be a count of 1, for the row that had 2 c....... Thanks!!!!!!!!!!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complex Count/CountIf calc | Excel Worksheet Functions | |||
how can I count (countif) the character: * | Excel Worksheet Functions | |||
count many with COUNTIF? | Excel Worksheet Functions | |||
Can one count cells having a certain format? i.e. using countif? | Excel Worksheet Functions | |||
Count, Countif, Sumif?? | Excel Worksheet Functions |