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.