YTD sum with one condition

[idontexcelinexcel]

hello, i need help on a formula.

basically, what i'm trying to do is i have months going across and two rows 1) actual 2) forecast
i want the formula to sum forecast only if there's a number other than zero in the actual.

for example. i will have forecast numbers for the whole year.
but i only have actuals from jan to july. so i want the formula to only add forecast numbers from jan to july.

see attached excel sheet.

thank you!

[cbatrody]

Hi,

Please try the following formula in O7:

=SUMIF(C6:N6,">"&0,C7:N7)

[Yogi52o]

See attached. I gave you two different formulas, so whatever you are most comfortable with!

[idontexcelinexcel]

SOLVED. that worked! thanks so much!

[cbatrody]

You are welcome

If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.

Also, you can directly thank those who have helped you by clicking on the small * (star) icon located in the lower left corner of a post that you have found to be helpful.