Hi,
I have 4 sheets. Sheet1 contains all the data. Sheet a should contain only data from the Sheet 1 where the column A contains value a. Same for the Sheet B and C
sheet1.PNG sheeta.PNG
I need to calculate in the column B of sheet a totals of the values in sheet 1 in column c where they correspond to the specific value so like in B1 I need to have 549
Please advice
Bookmarks