Hello everyone

I am very new at excel and i have done some google research but i cannot get any formula to work for me.

I have created a Pivot Table but due to it unable to auto refresh the data may not be acccurate.


I would like to sum a column based on date and region, example Below:
in colum "B" i have date, in column "H" i have region "AB", "VAN" ETC and in column "G" i have #.

i want to sum the # in column G if column B and H equal the specific date and region.

i hope this makes sense, please help