Forum Discussion
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 Period Name Narrative GBP 201902 Jane Doe Cakes 1.00 201806 Jane Doe ...
Hi Kwesi_Quartey, still I'm not clear with the output value. I didn't get that, could you please rephrase it again
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 Simple solution is to make the PivotTable for your data, kindly see the attached file
Regards, Faraz Shaikh