.. If there is anybody awake ..
Ah, half the world is awake at any one time

Assume real dates in A3:A10, Site#s in B1:C1, Area#s in B2:C2

If the Area#s are unique,
Assume that for an Area# input in A20
you want the total sales for Jan 2008

In B20, normal ENTER:
=SUMPRODUCT(--(TEXT(A3:A10,"mmmyy")="Jan08"),OFFSET(A3:A10,,MATC H(A20,B2:C2,0)))

If the Area#s are not unique, eg you may have the same area# in different
sites, then the uniqueness can be defined by using both Site# & Area#

In A20: Site#
In B20: Area#

Then in C20, normal ENTER:
=SUMPRODUCT(--(TEXT(A3:A10,"mmmyy")="Jan08"),OFFSET(A3:A10,,MATC H(A20&"#"&B20,B1:C1&"#"&B2:C2,0)))

Adapt to suit

P/s: For future new postings, pl use relevant phrases in your subject line
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,800 Files:359 Subscribers:56
xdemechanik
---
"Matthew" wrote in message
...
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