Here is an explanation of SumProduct.

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

I do not understand what you want to do if your data is stored on seperate
sheets. SumIf requires data to be in a table the same a sumproduct.
--
HTH...

Jim Thomlinson


"SUMIFS for excel 2003" wrote:

even when the values are located in diferent excel pages????

i have tried it didnt not work ..... what am i doing wrong???

where is this "discussion group"?????

"מיכאל (מיקי) אבידן" wrote:

SumProduct is your function.
There are plenty of examples in the Discussion Group.
Micky


"SUMIFS for excel 2003" wrote:

I want a formula that has a search for many different criterias:
EX:

Look for "Account",
Int the "Account Group" ... look for "Production"
In the "Production" column ... look for "January"

Is there a way to do this ...
any questions or misunderstandings or if you didn't understand what I said
please let me know because I will clarify any questions

Giorgio