Forum Discussion

Kwesi_Quartey's avatar
Kwesi_Quartey
Copper Contributor
Feb 20, 2020

Subtotals or Vlookups or Both.

Hi All 

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

 am working on a sheet, such as 

PeriodNameNarrativeGBP
201902Jane DoeCakes 1.00
201806Jane DoeCakes 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.

  

PeriodTotal 
2018074

 

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

Thanks 

 

Kwesi 

 

 

 

 

 

 

 

 

 

7 Replies

Resources