SumIf Function Question
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
|