Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 180
  • Last Modified:

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..
0
route217
Asked:
route217
  • 2
  • 2
2 Solutions
 
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
 
gowflowCommented:
Don't know if this is what you want

check the file.
gowflow
COUNTIF.xlsx
0
 
route217Author Commented:
Hi Gowflow..
that's correct dor edf and  let me test the attached workbook.
0
 
Saqib Husain, SyedEngineerCommented:
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now