Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I've got a 2000 row worksheet where I want to count the number of occurences
row where two row conditions are satisifed eg In the example below if I wanted to count where Col 1= A and Col 2 = 1, then I'd want the answer 2 returned A 1 B 2 A 3 C 4 A 1 In practice Col 1 has the rangename 'Place' and Col 2 has the rangename 'Customer' - if this helps answering this post Can someone save my sanity :( Tx in advance Rob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Please help me with a Conditional Count... | Excel Discussion (Misc queries) | |||
Conditional Count 2 Columns | Excel Worksheet Functions | |||
Conditional count of rows dependent on multiple columns | Excel Worksheet Functions | |||
Conditional Count | Excel Worksheet Functions | |||
conditional count | Excel Worksheet Functions |