Formula Help

[jahaynes]

I am trying to get the sum expenses on 25 sheets with specific data in a certain column. so say all 25 sheets have the data in column D that I want a total of and look for anything in column C that contains "7605". These numbers in column C could be from 760500-760599. Is it possible to do this? I have tried these formulas and they return 0, but the total should be 55,025.81

=SUMIFS(Atlanta!D:D,Atlanta!$C:$C,"*"&C2&"*")
=SUMIFS(Atlanta!D:D,Atlanta!C:C,"<="&C2,Atlanta!C:C,">="&C2)

this is just trying to get the formula to work with one sheet before trying to add the other 24 to the range.

Can this be done?

 

[Fluff]

The formula is stacking all the data from each sheet vertically & then filtering that data for for values in col C that start with 7605