I need to create a spread sheet that will add my total sales per region, but
I want to do it using an IF statement. The sample below is how I need to set
it up. I will be getting a separate worksheets that I am downloading from
our database.

I originally thought thank I can just do a link to each of the worksheets,
however the infomation does not always end up on the same rows and that means
I would have to modify my link each month. Long, Long time ago, I had a
spreadsheet similar to the one I need, and I remember that an If statement
was used to accomplish what I need. Can someone please help??

Loc Aug 08 Sept 08 October 08
1
2
3

Dolores, try something like this...

Col/Row A B C D
1 Loc Aug Sep Oct
2 1 34 54 86
3 2 34 75 35
4 3 23 57 43
5 1 75 87 87
6 2 34 98 54
7 3 22 54 67
8 222 425 372
9
10 Total by Location
11 1 109 141 173
12 2 68 173 89
13 3 45 111 110
14 222 425 372

Formula in Cell B11: =SUMIF($A$2:$D$7,$A11,B$2:B$7)

I tried dummying up data, then inserting column & row #s after I pasted the
example formula here...so hopefully I have the formula presented in the same
manner as the dummy data. Hope this helps.
--
Thx
MSweetG222



"Dolores" wrote:

I need to create a spread sheet that will add my total sales per region, but
I want to do it using an IF statement. The sample below is how I need to set
it up. I will be getting a separate worksheets that I am downloading from
our database.

I originally thought thank I can just do a link to each of the worksheets,
however the infomation does not always end up on the same rows and that means
I would have to modify my link each month. Long, Long time ago, I had a
spreadsheet similar to the one I need, and I remember that an If statement
was used to accomplish what I need. Can someone please help??

Loc Aug 08 Sept 08 October 08
1
2
3