I have a load of data 368X104 cells.......
This data is sales data by day per site.

Within this is also an area number so fo example:
a b c
1 Site No1 Site No2
2 Area No Area No
3 date1 Sales Sales
4 date2 sales Sales
5 date3 sales Sales
all i want to do is sum by area the vlaue of sales per day, the simple
way is a {sum(if......))} but I can not make this work for horizontal
not verticle. I am sure ther is a sipmple way, if you transpose then
you hit the 256 difficulty...


If there is anybody awake please help me

Regards

Matthew