Formula Required Please

**gunny1979** · 10-23-2006, 09:17 AM

Hi Guys,

I hope someone can help.
I have a spreadsheet which imports an html report.
In this report contains lists of dates and then a number 2 columns to the right of the date.

I am looking for a formula that will search the column and everytime the selected date appears will give me a sum of the number 2 columns to the right of each instance.

Thanks

Gunny

**carsto** · 10-23-2006, 12:16 PM

you said: search the column and everytime the selected date appears

I don't know how you intend to select the date
if you're entering a given date into a cell outside of the date column, use the SUMIF function.

if you want to just click on any date in the date column and make the formula calculate, I can't help you.

**gunny1979** · 10-24-2006, 08:22 AM

Sorry here is what im after if at all possible

Here is my Table

Arr Date Dep Date
23/10/06 24/10/06
23/10/06 25/10/06
23/10/06 24/10/06
23/10/06 26/10/06

Does anyone know of a function I can use to count how many times a person has an arrival date of what is in cell B9 and a departure date of what is in cell C9?

Thanks in Advance