I have a summary sheet of 30 staff (staff 1, staff 2 etc at top of
columns), dates down the A Column with figures in the relevant cells.
What I need is a formula to get "Totals" for months. Dates down the
left are weekly dates and range is named "Date", Figures under Staff 1
is named "Staff 1", Staff 2 is named "Staff 2" etc. I have the months
listed in cells B34:B46 and want the total for the relevant months in
C34:C36.

I just want the formula for "staff 1", I should be able to work the
rest out from that.

Any help would be appreciated.

TIA
Esra

=SUMPRODUCT((YEAR(A2:A20)=2008)*(MONTH(A2:A20)=3)* (B2:AE20))

--
__________________________________
HTH

Bob

"Esradekan" wrote in message
...
I have a summary sheet of 30 staff (staff 1, staff 2 etc at top of
columns), dates down the A Column with figures in the relevant cells.
What I need is a formula to get "Totals" for months. Dates down the
left are weekly dates and range is named "Date", Figures under Staff 1
is named "Staff 1", Staff 2 is named "Staff 2" etc. I have the months
listed in cells B34:B46 and want the total for the relevant months in
C34:C36.

I just want the formula for "staff 1", I should be able to work the
rest out from that.

Any help would be appreciated.

TIA
Esra

On Aug 28, 9:45*am, "Bob Phillips" wrote:
=SUMPRODUCT((YEAR(A2:A20)=2008)*(MONTH(A2:A20)=3)* (B2:AE20))

--
__________________________________
HTH

Bob

"Esradekan" wrote in message

...



I have a summary sheet of 30 staff (staff 1, staff 2 etc at top of
columns), dates down the A Column with figures in the relevant cells.
What I need is a formula to get "Totals" for months. *Dates down the
left are weekly dates and range is named "Date", Figures under Staff 1
is named "Staff 1", Staff 2 is named "Staff 2" etc. *I have the months
listed in cells B34:B46 and want the total for the relevant months in
C34:C36.

I just want the formula for "staff 1", I should be able to work the
rest out from that.

Any help would be appreciated.

TIA
Esra- Hide quoted text -

- Show quoted text -

No, sorry.

Date range is not a whole year, part of one year and part of another
(ie. April 2008 to March 2009), but just doesnt seem to work.

Esra

I presume this is not working for you, but I do not understand the deetails.

--
__________________________________
HTH

Bob

"Esradekan" wrote in message
...
On Aug 28, 9:45 am, "Bob Phillips" wrote:
=SUMPRODUCT((YEAR(A2:A20)=2008)*(MONTH(A2:A20)=3)* (B2:AE20))

--
__________________________________
HTH

Bob

"Esradekan" wrote in message

...



I have a summary sheet of 30 staff (staff 1, staff 2 etc at top of
columns), dates down the A Column with figures in the relevant cells.
What I need is a formula to get "Totals" for months. Dates down the
left are weekly dates and range is named "Date", Figures under Staff 1
is named "Staff 1", Staff 2 is named "Staff 2" etc. I have the months
listed in cells B34:B46 and want the total for the relevant months in
C34:C36.

I just want the formula for "staff 1", I should be able to work the
rest out from that.

Any help would be appreciated.

TIA
Esra- Hide quoted text -

- Show quoted text -

No, sorry.

Date range is not a whole year, part of one year and part of another
(ie. April 2008 to March 2009), but just doesnt seem to work.

Esra

=SUMPRODUCT(--(MONTH(C34:C46)=relevantmonths),D34:D46)

You didn't state how you get your months to choose, so you'll have to
add that in.

Months to choose are in B34:B46 - thought I did state that.

Thanks anyway.

Esra

On Aug 29, 4:13*am, Spiky wrote:
=SUMPRODUCT(--(MONTH(C34:C46)=relevantmonths),D34:D46)

You didn't state how you get your months to choose, so you'll have to
add that in.

And, exactly WHAT is in c34:c46?
1,2,3,5
Jan,Feb,Mar,

In your ORIGINAL post, you should endeavor to explain FULLY since mind
reading is another group.
Eventually, you will learn.............

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Esradekan" wrote in message
...
Months to choose are in B34:B46 - thought I did state that.

Thanks anyway.

Esra

On Aug 29, 4:13 am, Spiky wrote:
=SUMPRODUCT(--(MONTH(C34:C46)=relevantmonths),D34:D46)

You didn't state how you get your months to choose, so you'll have to
add that in.

On Aug 28, 9:48 pm, Esradekan wrote:
Months to choose are in B34:B46 - thought I did state that.

Thanks anyway.

Esra

I misunderstood something, and your explanation was a bit confusing.
Is this the setup?

You have data listed in A1:[?]30; with dates in A, Staff1 in B, Staff2
in C, etc. You have a list of months in B34:B46. You want a total for
those months in C34:C46.

If that's correct, then these ought to work (and be able to be copied
for the others), although I haven't tested it:
=SUMIF(Date,$B34,Staff1)
=SUMPRODUCT(--($A$1:$A$30=$B34),B$1:B$30)

Also:
You said your Name for staff 1 is "Staff 1". That doesn't seem correct
because I don't believe Excel allows for spaces in Names. You'll have
to correct my formula with the precise Names.