You'll need to replace F2:F20 (for example) with something like this:
Sheet2!F2:F20. Just make sure that each range is the same length.

Good luck!

"I have no idea" wrote:

Success. I think I have it working.
Now for the next one, can i produce that sumproduct calculation into a
different sheet? In short, can i combine the sumproduct calcultion from two
seperate sheets Say 05-06 and 06-07 into Sheet 3?

Thankyou for your patience.

"Barb Reinhardt" wrote:

Try typing in the value that you are checking for in one of the cells and see
if it works then.

"I have no idea" wrote:

I've checked and no extra space is there.
I autofiltered as you suggested and $550.00 is what came up.

"Barb Reinhardt" wrote:

Try something for me. Use autofilter to select all the rows that match the
conditions you want and see if you get $550. I'm wondering if the value in
the account # is something like " 12345" instead of "12345".

"I have no idea" wrote:

I'm sure this is simple nut I have no idea!
(Apologies for incorrect terminoligies)

*Background*
My workbook two worksheets of data.
I want to sum up the values of a range of cells, within a coloum, from both
of these worksheets into a new sheet and the values are based on more than
one criteria.

The info i wanted sumed is in $ format, the criteria in both worksheets are
the same and each worksheet will have a new row added almost daily.

*Example*
Problem 1-
On both worksheets:
Coloum I has a drop down list with two choices "Op" and "Inv"
Coloum J has a drop down list with choices as well "24501", "23120" and
"21005"
Coloum K has a dropdown list with choices as well "BucketOne", "BucketTwo"
and so on.
Coloum L has the value in $ format entered manually.

Question-
How do I sum up in a different sheet all of the values based on "Op" "23120"
"BucketTwo" from both worksheets?

Question-
How do I then seperate that info by the date I choose from say Coloum Z?

Question-
How do I E-mail the person identified in Coloum A that info automatically
when the date in Coloum Z comes around?

Summary
I am the most basic of excel user,so "dumbing down" an answer that even half
solves my problem would be greatlly appreciated.

Thanx