Hi,

I have a sheet of sales data (c1000 lines) and need to sum it all up into
areas.

My sales data is:
Area,Value,Include
1,10,Yes
2,9,Yes
3,8,No
4,7,No
5,6,Yes
1,5,Yes
2,5,Yes
3,2,No
4,10,No
5,6,Yes

My results table needs to show the following:

Area,Value
1,15
2,14
3,0
4,0
5,12

Basically I need to sum the value for each area 'only' if the Include column
= yes.

I've tried looking at the info on xldynamic.com but can't seem to get the
right formula together, not sure if I need a sumif or maybe a sumproduct?

Any help would be appreciated.

Thanks in advance.

AW