Adding values that has a corresponding blank cell

[scare_xl]

Hi All,

I'm new to this forum.

I have been working on a spreadsheet that has data from "A" to "CA", the number of rows will change each week, one week it will be 500 and the other week it maybe 5000.

Column "A" has codes such as CVVLUWW along with blank cells and Column "G" has days that can range from 1 to infinity, and Column "H" $ values.

I want to add the values of blank cells in "A" which falls in to the below date ranges - <45, 45-90, 90-120, 120-150, 150-180 and >180.

Any ideas how to do this is great as I have been trying to figure this out for weeks.

[martindwilson]

workbook please with examples!
not only cross posted but a different user name and slightly rephrased question and answered! before this was posted ???????????
at
http://www.mrexcel.com/forum/showthread.php?t=410015