Count the number of records in a range

[Dinesh_Excel]

Hi All,

I have a data where I need to pull the count of certain columns .

The data has been basketed in to 3 groups and we need to get the counts under each group.

Attached sheet along with the base sheet for your reference.

Even a vba code will be helpful .

 

[Monty]

Hello Dinesh.

Excel attatched.

Am not sure, am done as per your requirment..Correct me if am wrong.

Happy to help you.

 

[Nebu]

Hi:

Is this what you are looking for?

Thanks

 

[Dinesh_Excel]

Hi Nebu,

we should have sum instead of count against each workgroup.
can we achieve this?

Attached sample for your reference.

 

[Nebu]

Absolutely, you can use sumproduct to achieve this.

Thanks

 

[Dinesh_Excel]

Excellent Nebu....thanks all