Year to Date Cummulative Totals

[Carlee]

I have a sheet of data each containing date in column B.

On another sheet called 'Monthly Summary', a column 'C', called year to date
total.

At the top of the 'monthly summary' sheet, have a lookup box containing a
list of months.

Question:
How can i get a year-to-date cummulative total placed into column C, up to
the last date for the month selected in the lookup box? So, if selected
June, i could get a cummulative total for a specific column from my data
sheet, say column F, based on the month selected in the monthly summary sheet?

 

[Carlee]

Here is a bit more information to be more specific:

This is what I need to be able to do:

1. On the Monthly SUmmary Sheet, select a month from the Drop down list
2. Have Excel Search the Data Sheet, for all values in a specific column,
say 'F', matching the month selected
3. Sum the selected data
4. Place the summed value in a specified location on teh Monthly Summary,
say cell B5

Make more sense?

 

[dan dungan]

Hi Carlee,

In excel 2000, I would use the combo box linked cell property value as
a variable in a countif formula in B5.

if the linked cell in the combobox were B4, the formula in B5 would
look like:

=countif(F:F,B4)

I haven't tested this.

Dan