Step 1: works great!

Step 2,3, & 4 I'm having issues with. They seem to make sense, but I'm not
sure why they will not work.

This is what I put.
Step 2:
=SUMIF(Month('Global Schedule'!L:L),"="&MONTH(NOW()),'Global Schedule'!N:N)
Step 3:
=SUMIF(Month('Global Schedule'!L:L),"="&MONTH(NOW())+1,'Global Schedule'!N:N)
Step 4:
=SUMIF(Month('Global Schedule'!L:L),""&MONTH(NOW())+1,'Global Schedule'!N:N)

Thanks,
Ryan


"michael.beckinsale" wrote:

Hi Ryan,

I have not tested this nut it should point you in the right direction

1.) Sum all cells in Col. N if the cell in the same row in Col. L has a
value. This is what I got, but it does not work:

=SUMIF('Global Schedule'!L:L,ISBLANK() = FALSE,'Global Schedule'!N:N)

change to:

=SUMIF('Global Schedule'!L:L,<"",'Global Schedule'!N:N)

2.) Sum all cells in Col. N if the cell in the same row in Col. L is a date
within the current month.

something like:

=SUMIF(Month('Global Schedule'!L:L),Month($A$1),'Global Schedule'!N:N)


3.) Sum all cells in Col. N if the cell in the same row in Col. L is a date
within the next month.


=SUMIF(Month('Global Schedule'!L:L),Month($A$1)+1,'Global Schedule'!
N:N)


4.) Sum all cells in Col. N if the cell in the same row in Col. L is a date
after the next month.

=SUMIF(Month('Global Schedule'!L:L),Month($A$1)+2,'Global Schedule'!
N:N)


Where cell A1 contains a date within the required current month


Regards

Michael