Summing data based on range

[markb141]

Hi,

I have an excel spreadsheet that has the difference between a given and today's date as the column headings and Names as a row heading. What I am try to do is sum the numbers between colunms if they fit within a numerical range by name.

For example if the date difference column is less than -60 sum the cell(s) by name. sometimes it could be from just one column or more columns.

I'm not sure if a sumifs statement would work or doing a vlookup.


I have attached some sample data to help, with the green filled cells the ones I want to be automatically populated.

Any help is greatly appreciated as I am totally stumped.

[Punnam]

Hi,

Check the file Conform it works fine or not?

Punnam

[markb141]

Punnam,

Yes that is just what I needed.

Thank you so much life saver.

1+ Star.

Mark

[Punnam]

Marbb141,

Thanks for the rep.
mark the thread as solved using the thread tools .

Punnam

[Punnam]

Marbb141,

Thanks for the rep.
mark the thread as solved using the thread tools .

Punnam