SUM and OFFSET

[gewf631]

I've used these in the past, but must be having a brain freeze, so please bear with me...


Simple monthly data, with column A being month, column B actual sales, column C budgeted sales


I have monthly budget data, and would like to calculate year-to-date based on the number of actual months in column B


A B C

Jan 50 50

Feb 40 55

Mar 54

Apr 51

May 50

Jun 53

YTD 90 xxx (which should be 105)


Thanks in advance

 

[Luke M]

You want a sum of rows where there's actually something in col C, correct?

=SUMIF(C:C,">0",B:B)

 

[gewf631]

Luke M

Never even thought to use the SUMIF function.


Wow, simplicity at it's finest!


Don't know why I was thinking I'd have to use a dynamic range.


Thanks!

 

[Luke M]

No worries. Sometimes we all just need an outside perspective. =)

 

[xcruc1at3r]

WHY DO WE USE , ">0" WHAT DOES IT MEANS!

 

[xcruc1at3r]

it means if values in column C are gr8ter then 0 so sum C and B !!

 

[Hui]

It means Sum Column B where Column C is > 0