Comparing dates and adding up results

  • Thread starter Thread starter Chuck
  • Start date Start date
C

Chuck

Very New to Excel
I have 2 columns A & B with results going into a certian
row on F A contains manualy entered dates, B contains
amoumts . F contains month totals from A if they are for
correct month and year.

01/15/04 1500.00 Jan
12/14/03 85.00
01/22/04 100.00

How do I convert entire columns to find out if they meet
correct month and year?
F1
=SUMPRODUCT((A1:A100=2004)*(A1:A100=01)*(b1:b100))
 
Hi Chuck!

Try:
=SUMPRODUCT((YEAR($A$1:$A$100)=2004)*(MONTH($A$1:$A$100)=1)*($B$1:$B$1
00))


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Norman,
Thank you very much !!
That's excatly what I needed I couldn't figure out how to apply the year()
and month() to a whole column.

Chuck
 
Hi Chuck!

Thanks for thanks. Always pleased to help.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top