Multi Criteria

**impulse03** · 11-15-2011, 09:43 PM

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

**abousetta** · 11-15-2011, 10:16 PM

Only in Calgary would someone have a copy of XL 20

No, just joking... what version of excel do you have 2003, 2007 or 2010? If post-03 then you can use Sumifs... Please post an example workbook.

abousetta