Having a formula count only specific dates.

**szm187** · 03-15-2012, 11:08 AM

Sorry, that title is atrocious for what I'm trying to do...

Basic premise: On one sheet, I have two primary columns. One just has a date. It goes in order of the calendar year, but some dates may appear twice or three times in different rows, others none. They would appear sequentially. The second column just has a dollar amount.

i.e.

3/15/12 $10000
3/15/12 $12000
3/17/12 $15000

etc.

On a second sheet, I would like to make a formula that references what money is there for a given day.

So, for March 15th, it would tabulate $22,000, March 16th, $0, and March 17th $15,000.

And it would auto-adjust if I inserted new dates & numbers into the first sheet.

I tried a couple of things and didn't have much luck, I included a sample of the first sheet for reference. Any help would be appreciated.

**Fotis1991** · 03-15-2012, 11:16 AM

Hi

In Sheet2! A1, put the date that you need. Then in B1, put this formula.

=SUMPRODUCT(('Anticipated Cash'!A2:A138=Sheet2!A1)*('Anticipated Cash'!B2:B138))

Hope to helps you.

**MarvinP** · 03-15-2012, 11:25 AM

Hi szm187,

This looks like a Pivot Table question to me. In your data you need to add all dates so you don't get blanks. You also need to remove the empty rows so it is an excel table. Then do a pivot on it. I've summed by date and also done a running total column. See if this works for you.