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?

 

[RobP]

So do you only want to sum Col D if Col C has that "7605" inside it ?

thanks
Rob

 

[jahaynes]

I want it to sum if it contains because it could the 760510, 760515, 760520, etc. I need the totals for all cells in C that contain those first 4 numbers

 

[Fluff]

Hi & welcome to MrExcel.
If col C are all numbers from 760500 to 760599 then they all match your criteria.

 

[jahaynes]

This is what is in those columns and the formulas I used returned 0

 

[Fluff]

How about

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

 

[JazzSP8]

Try;

=SUMIFS(D:D,C:C,">=760500",C:C,"<=760599")

?

 

[jahaynes]

Try;

=SUMIFS(D:D,C:C,">=760500",C:C,"<=760599")

?

Thank you!!!! That worked!!!

 

[Fluff]

Why do you need to do that if all numbers are between those limits?
Did you try what I suggested?

 

[Burrgogi]

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?

Rather than expressing your data as text it would be easier if you expressed them as numbers. Try this formula:

=SUMIFS(D:D, C:C, ">=760500", C:C, "<=760599")