Go Premium for a chance to win a PS4. Enter to Win

x
Solved

# formula to count number of accounts a customer has

Posted on 2014-03-06
Medium Priority
179 Views
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
Question by:route217
• 2
• 2

LVL 31

Expert Comment

ID: 39909794
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

LVL 31

Accepted Solution

gowflow earned 1000 total points
ID: 39909822
Don't know if this is what you want

check the file.
gowflow
COUNTIF.xlsx
0

Author Comment

ID: 39909864
Hi Gowflow..
that's correct dor edf and  let me test the attached workbook.
0

LVL 43

Assisted Solution

Saqib Husain, Syed earned 1000 total points
ID: 39909963
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

Author Comment

ID: 39917086
Thanks ssaquib
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
###### Suggested Courses
Course of the Month11 days, 19 hours left to enroll