Formula's across multiple sheets

[Simon]

Many thanks to those that have already helped me,

Right another niggle has now cropped up, I need to make my
formula look across many sheets for the data. For example
the formula I currently have is ........

=SUMPRODUCT(('[Anthony Week 42.xls]Wednesday'!C2:C50="Tina
Shields")*('[Anthony Week 42.xls]Wednesday'!
B2:B50="Outstanding Balance"))

This formula finds out how many Outsatnding Balance
queries Tina Shields raised on Wednesday but I now need to
find out how many across the week. There are 5 sheets
named Mon - Fri but I can't get it to return a value.

many thanks for the help

Simon


Ps. here is my original post...............................


Right its a worksheet in Excel 2003.

Caller Query
Joe A Complaints
Joe B Complaints
Joe A Complaints
Joe A Shipping
Joe A Refund
Joe B Complaints
Joe A Complaints

Above is what my worksheet looks like. In another
worksheet I need a formula for a cell to count how
complaints/shipping queries each caller takes. So for
example in my results sheet it should show:

Shipping Complaints
Joe A 1 3

I need a formula to do the above??

Any help would be very much appreciated.

Many Thanks in advance.

Simon

............................................................

 

[Paul]

Many thanks to those that have already helped me,

Right another niggle has now cropped up, I need to make my
formula look across many sheets for the data. For example
the formula I currently have is ........

=SUMPRODUCT(('[Anthony Week 42.xls]Wednesday'!C2:C50="Tina
Shields")*('[Anthony Week 42.xls]Wednesday'!
B2:B50="Outstanding Balance"))

This formula finds out how many Outsatnding Balance
queries Tina Shields raised on Wednesday but I now need to
find out how many across the week. There are 5 sheets
named Mon - Fri but I can't get it to return a value.

many thanks for the help

Simon

You will need 5 formulas similar to the one you already have, or one long
one simply adding 5 such parts.

 

[Don Guillett]

You need to use a formula for each or have the formula in the same place on
each sheet and use
=sum(sheet1:sheet5!b2)
to sum all the sumproducts

--
Don Guillett
SalesAid Software
(e-mail address removed)

Many thanks to those that have already helped me,

Right another niggle has now cropped up, I need to make my
formula look across many sheets for the data. For example
the formula I currently have is ........

=SUMPRODUCT(('[Anthony Week 42.xls]Wednesday'!C2:C50="Tina
Shields")*('[Anthony Week 42.xls]Wednesday'!
B2:B50="Outstanding Balance"))

This formula finds out how many Outsatnding Balance
queries Tina Shields raised on Wednesday but I now need to
find out how many across the week. There are 5 sheets
named Mon - Fri but I can't get it to return a value.

many thanks for the help

Simon


Ps. here is my original post...............................


Right its a worksheet in Excel 2003.

Caller Query
Joe A Complaints
Joe B Complaints
Joe A Complaints
Joe A Shipping
Joe A Refund
Joe B Complaints
Joe A Complaints

Above is what my worksheet looks like. In another
worksheet I need a formula for a cell to count how
complaints/shipping queries each caller takes. So for
example in my results sheet it should show:

Shipping Complaints
Joe A 1 3

I need a formula to do the above??

Any help would be very much appreciated.

Many Thanks in advance.

Simon

...........................................................