Month totals from list

  • Thread starter Thread starter GerryK
  • Start date Start date
G

GerryK

Hi,
I'm trying to get month totals per tasks in columns by
using:

(My January example)
=SUMPRODUCT((MONTH('F Export'!$D$3:$D$9999)=MONTH(1))*('F
Export'!$B$3:$B$9999=34)*'F Export'!$J$3:$J$9999)

where:
column D are dates as 5/14/2004
column B are numeric codes for tasks
column J has the amount(s) I would like added up for each
month in their respective column.

My problem is that I do not get different amounts by month
rather get 24 for every month.

How can I re-write the month parameter?
TIA
 
Hi
try
=SUMPRODUCT((MONTH('F Export'!$D$3:$D$9999)=1)*('F
Export'!$B$3:$B$9999=34)*'F Export'!$J$3:$J$9999)
 
Back
Top