View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RFJ RFJ is offline
external usenet poster
 
Posts: 25
Default Conditional count across 2 columns

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