formula to count number of accounts a customer has

Hi Experts  Excel 2007

I need a formula t.         10o count how many account a customer has...so assume the following table
Col A.                  Col B.               Col C.           Count
Co.                      A count.          Sort code.      Total
Abc.            12345678.           202020.                1
Edf.              13445892.         102030.                 2    
                    23868908.          102030
Ikb.            23468990.           026978.              1

Etc..
route217Asked:
Who is Participating?
 
gowflowConnect With a Mentor Commented:
Don't know if this is what you want

check the file.
gowflow
COUNTIF.xlsx
0
 
gowflowCommented:
The data is not aligned best is to post a sample workbook.

Furthermore your data in Col A has only unique items not repetitive ? like Edf. Shows once it is meant for both rows ?

gowflow
0
 
route217Author Commented:
Hi Gowflow..
that's correct dor edf and  let me test the attached workbook.
0
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
Enter this ARRAY formula in row 2 of any blank column and then copy it down

=IF(A2="","",IF(A3="",IFERROR(MATCH(TRUE,A3:$A$16<>"",0),1+ROWS(A3:$A$16)),1))

Change both 16s to the last data row.

Do you know how to enter an array formula?
0
 
route217Author Commented:
Thanks ssaquib
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.