Conditional sumif
 

In my budget comparison worksheet, I need to compare CYTD to PTYD totals and
would like to write conditional sumif that totals PYTD based on the month
(i.e, total A1:A1 if mo. = 1, total A1:B1 of mo. =2, A1:C1 if mo.=3 and so
on). Thank you.

Conditional sumif
 

=SUM(A1:OFFSET(A1,0,0,1,mo.))
assuming "mo." is the defined name, otherwise you can use the MONTH function
of the cell containing the date (if the date is in Z1, for example,
=SUM(A1:OFFSET(A1,0,0,1,MONTH(1)))


"wilson@irco" wrote in message
...
In my budget comparison worksheet, I need to compare CYTD to PTYD totals
and
would like to write conditional sumif that totals PYTD based on the month
(i.e, total A1:A1 if mo. = 1, total A1:B1 of mo. =2, A1:C1 if mo.=3 and
so
on). Thank you.

Conditional sumif
 

Check out offset, like =sum(offset(a1,0,0,1,#_Months))
If the # of months is in a cell, you can put the cell reference in the final
argument.

"wilson@irco" wrote:

In my budget comparison worksheet, I need to compare CYTD to PTYD totals and
would like to write conditional sumif that totals PYTD based on the month
(i.e, total A1:A1 if mo. = 1, total A1:B1 of mo. =2, A1:C1 if mo.=3 and so
on). Thank you.

Conditional sumif
 

Thank you Bob...it works nicely!

"Bob Umlas" wrote:

=SUM(A1:OFFSET(A1,0,0,1,mo.))
assuming "mo." is the defined name, otherwise you can use the MONTH function
of the cell containing the date (if the date is in Z1, for example,
=SUM(A1:OFFSET(A1,0,0,1,MONTH(1)))


"wilson@irco" wrote in message
...
In my budget comparison worksheet, I need to compare CYTD to PTYD totals
and
would like to write conditional sumif that totals PYTD based on the month
(i.e, total A1:A1 if mo. = 1, total A1:B1 of mo. =2, A1:C1 if mo.=3 and
so
on). Thank you.