Hey everyone! Glad to be a part of the community and I think I’ll be able to get some good advice from the group!

I’m trying to sum a value across multiple sheets as long as it meets a certain condition. I had this formula working before when it was 5 sheets. I did 5 separate SUMIF statements and had them all add together. The workbook is now 12 sheets and growing, so I was hoping to have one formula to sum across a range of sheets, as long as the condition is met.

All the sheets are set up the exact same. Where column C is the total amount of money remitted, and column D is the invoice number it belongs to.

Here is what I’m using as a formula:

=SUMIF('038980:040201'!D:D,"51350",'038980:040201'!C:C)

It returns an error, any ideas?