Sum range if the values of another column are equal to a cell value & month

[Dee2015]

I need a formula to populate B4 thru B16, based on the following conditions. I need to sum up all the values in column K (sheet 'SAP PM' top) that have the value of B1 (Sheet 'Cost CM of Location' bottom), in columns C (sheet 'SAP PM' top) and for the month specified in B4 thru B16. B1 is not a fixed value but is linked to a different sheet that has a dropped down list, so If I change the value B1 will change, and so should B4 thru B16. For example, B1 is showing 11697821, so in B$ the value should be adding all the cost from column K, in which column C has the same value as B1 and column H fall in the month of April, since there's only one row this value should be $1309.05. Please see figure below.

I don't know much on vba so mostly I work with formulas in cells or multiple cells.

Thanks in advance for the help.

[nigelbloomy]

Would this work for you? I am assuming the months in the first picture are actually dates formatted to just show the name of the month.

Please Login or Register  to view this content.

[Dee2015]

Hi,

Well it was only text and not dates, but I formatted it to show Month and year. The function is not working properly it brings random cost from the SAP PM sheet, not really tied to the value of B1, it does bring cost values just not the correct one's. I noticed you placed the formula for DATE, the value 1 for Day is that suppose to change? does it bring all dates from the month?

Thanks
Diana

[Dee2015]

Actually it did work, I was transferring the formula incorrectly, and for the life of me I wasn't noticing until now that one of the ranges I hadn't put the $$ to keep it from changing...Thanks a lot for your help!

[nigelbloomy]

Oh good, I'm glad it ended up working.