Hi


=SUMPRODUCT(--('Global
Schedule'!$J$3:$J$10000DATE(YEAR(TODAY(),MONTH(TO DAY(),0),--('Global
Schedule'!$J3:$J$10000<DATE(YEAR(TODAY(),MONTH(TOD AY()+1,1),'Global
Schedule'!$N$2:$N$10000)

=SUMPRODUCT(--('Global
Schedule'!$J$3:$J$10000DATE(YEAR(TODAY(),MONTH(TO DAY()+1,0),--('Global
Schedule'!$J3:$J$10000<DATE(YEAR(TODAY(),MONTH(TOD AY()+2,1),'Global
Schedule'!$N$2:$N$10000)

=SUMPRODUCT(--('Global
Schedule'!$J$3:$J$10000DATE(YEAR(TODAY(),MONTH(TO DAY()+2,0),'Global
Schedule'!$N$2:$N$10000)

Adjust ranges.
NB! SUMPRODUCT doesn't allow references to whole column. Refer to range with
enough spare rows, or use dynamic named ranges instead!
NB! All ranges used in sumproduct as source ranges MUST be of same dimension
(include same number of rows)!

--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"RyanH" wrote in message
...
I have a very large Worksheet labeled 'Global Schedule'. The first 2 rows
are used as a header. In Col. J there are dates and in Col. N there are
prices. At any given time Col. J cells may or may not have a date. I
would
like
the formula placed in a worksheet labeled 'Summary'. Here is what I have,
but it does not seem to work.

1.) Sum all cells in Col. N if the cell in the same row in Col. J is a
date
within the current month.
=SUMIF(Month('Global Schedule'!J:J),"="&MONTH(NOW()),'Global
Schedule'!N:N)

2.) Sum all cells in Col. N if the cell in the same row in Col. J is a
date
within the next month.
=SUMIF(Month('Global Schedule'!J:J),"="&MONTH(NOW())+1,'Global
Schedule'!N:N)

3.) Sum all cells in Col. N if the cell in the same row in Col. J is a
date
after the next month.
=SUMIF(Month('Global Schedule'!J:J),""&MONTH(NOW())+1,'Global
Schedule'!N:N)

Thanks,
Ryan