=SUMPRODUCT(--('X:\DEPT\Confidential\Confindential\[Candace - Confidential
Customer Communication
Tracker.xls]Sheet1'!$I$3:$I$590=G3),--('X:\DEPT\Confidential\Confidential\[Candace
- Confidential Customer Communication
Tracker.xls]Sheet1'!$C$3:$C$590="1"),(--('X:\DEPT\Confidential\Confidential\[Chris
- Confidential Customer Communication
Tracker.xls]Sheet1'!$I$3:$I$590=G3)),(--('X:\DEPT\Confidential\Confidential\[Chris
- Confidential Customer Communication Tracker.xls]Sheet1'!$C$3:$C$590="1")))

I need to add three more spreadsheets. (I put confidential in places that I
cannot show what information I have.)

Thank you.

"Pete_UK" wrote:

It would help if you posted your formula.

If you are unsure that it works, perhaps you could try to write it
for, say, two worksheets and test it out that way, and then
extrapolate as required to encompass the other worksheets.

Hope this helps.

Pete

On Jul 2, 2:25 pm, LiveUser
wrote:
I have 5 separate spreadsheets that I am pulling information from. The
problem is I receive an error that my formula is too long. Not only that, but
I don't even know if my formula will work.

I want the total amount of the number "1" in cell H3 coming from a specific
column in multiple spreadsheets that are on a specific date specified in G3.

On the other spreadsheets the column with numbers in it is D and the dates
are in column I.

Is this possible?

Thank you.