Help with IF Sum Function

  • Thread starter Thread starter ahleah
  • Start date Start date
A

ahleah

I need assistance with what I "think" would be an If Sum Function.

I have 2 sections of a worksheet, the top shows the current expenses b
month (JAN, FEB, etc). The second sections shows the Budget by mont
(JAN, FEB, etc).

What happens is the current expense columns will not always hav
values, but the budget section does for the whole year.

I need the YTD (year to date) Budget column to ONLY sum IF the firs
section (current expense) has a value.

For instance I have expenses for Jan and Feb, but not March...but th
Budget section of course shows figures for Jan - Dec, but at thi
point, I only want the Budget section to sum the Budgeted figures fo
Jan and Feb and ignore the Mar-Dec values.

HOW do I accomplish this??

ANY help would be greatly appreciated!! :o
 
Without knowing your formula or how your sheet is set up, here's a guess:

If you monthly expense totals are in row 35 and say column A is Jan. and B
is Feb ... etc.
And your monthly budget totals are in row 65, in the same columns,
then try:

=SUMIF(A35:L35,">0",A65:L65)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================





I need assistance with what I "think" would be an If Sum Function.

I have 2 sections of a worksheet, the top shows the current expenses by
month (JAN, FEB, etc). The second sections shows the Budget by month
(JAN, FEB, etc).

What happens is the current expense columns will not always have
values, but the budget section does for the whole year.

I need the YTD (year to date) Budget column to ONLY sum IF the first
section (current expense) has a value.

For instance I have expenses for Jan and Feb, but not March...but the
Budget section of course shows figures for Jan - Dec, but at this
point, I only want the Budget section to sum the Budgeted figures for
Jan and Feb and ignore the Mar-Dec values.

HOW do I accomplish this??

ANY help would be greatly appreciated!! :o)
 
Back
Top