View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
michael.beckinsale michael.beckinsale is offline
external usenet poster
 
Posts: 274
Default 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