Sum Across Multiple Sheets with Look Up Function

[ArtofDisguise]

Hi there, I am new to this forum, and I am looking for help to create a formula that sums values in the same column across three sheets on a summary tab (sheet four). However, each sheet has a different number of rows, but each row has a unique identification code. Is there a way to sum the values in "Column P" across three sheets by matching each value to its unique identification code in "Column F"? The unique identification code is also located in sheet fourth which is the summary tab. What would the formula look like? Thank you for the help.

 

[FDibbins]

You could use something like this...

=SUMPRODUCT(SUMIF(INDIRECT("'"&Tabs&"'!T6:T1000"),C794,INDIRECT("'"&Tabs&"'!M6:M1000")))
where tab is a named range for a list of all your sheets

 

[ArtofDisguise]

I keep receiving an error message after typing in my formula. I pasted it below. Can someone please help me? If the number of rows does not match in each sheet, would that be a problem? Is there a way to use the match function instead? Thank you=Sumproduct(Sumif(Indirect({"'Jan'!F3:F93","'Feb'!F3:F93","'Mar'!F3:F93"}),'Q1'!B3,({"'Jan'!P3:P93","'Feb'!P3:P93","'Mar'!P3:P93"}))).

 

[ArtofDisguise]

I noticed that I forgot to put in a second INDIRECT function into the sum range, which fixed the problem. However, I tried to copy and paste the formula and change the columns for the corresponding ranges that need to summed, but I get zeros for every cells.