Subtotals or Vlookups or Both.

[Kwesi_Quartey]

Hi All 

I would be grateful if someone could help me to find a solution 

 am working on a sheet, such as 

Period	Name	Narrative	GBP
201902	Jane Doe	Cakes	1.00

201806

Jane Doe

Cakes

1.00

and I have applied a filter for the Narrative column "cakes". 

So after this,  I need to show the count total for the Period column eg "201902" 

I'm trying to achieve something like this at the end.

Period	Total
201807	4

I don't want to be counting multiple 201806's and getting the total of them wrong.

Thanks 

Kwesi 

[#2]

Hi @Kwesi_Quartey , are you trying to list the unique count as per Narrative ? share the sample workbook with your desired output

[#3]

@Faraz Shaikh 

Yes, I am. I have added an attachment.  

[#4]

Hi @Kwesi_Quartey, still I'm not clear with the output value. I didn't get that, could you please rephrase it again 

[#5]

@Faraz Shaikh 

I want to be able to count all the "201806" in the period column and to display the total amount of "201806" in the total column. after I have applied the filter from the other main table.

Period	Total
201902	1
201806	1

[#6]

Hi @Kwesi_Quartey 

Simple solution is to make the PivotTable for your data, kindly see the attached file 

Regards, Faraz Shaikh

[#7]

@Faraz Shaikh 

lol thanks, I guess I was thinking too much 

[#8]

Glad to hear your query is resolved

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert | www.ExcelExciting.com