Excel Formula to be used

[Ramesh_vm]

Hello .. I have the data in Sheet1 and i want the Consolidation data for each person's in Sheet2. (like What is the Total counts for Ramesh,Rohan etc...) So in Sheet2 - Column2 what will be the best formula to use..


Names Products Total Counts

Ramesh Pen 5

Rahan Cartsheets 3

Subhod Paint 4

Ramesh Rubber 2

Rahan Scale 8

 

[sgmpatnaik]

@Ramesh


Hi


i think it is a cross posting / hijack post because the same type question asked in the below link


http://chandoo.org/forums/topic/formula-in-excel


if it is not then please upload a sample file, to upload a sample please check the below link


http://chandoo.org/forums/topic/posting-a-sample-workbook


and one more thing i would like to remind please provide full details it is better to understand the Ninja's and Forum Readers who will try to solve your problem


Thanks


SP

 

[srinidhi]

The best deal is Table, if you want a formula, In Sheet 2 Column1, add the unique names of all the persons & in Column2, enter the CountIf formula.