Help! I can't seem to wrap my head around writing in if blank leave blank into the formula below. What I need is if B6 is blank leave C6 blank otherwise when I put a total in B6 I need the formula below to calculate. It is a rolling 12 month average. Your help would be greatly appreciated.
Formula currently in Cell C6
=SUM(D7:D$15,B$4:B6)/12
Maybe:
=IF(C6="","",SUM(D7:D$15,B$4:B6)/12 )
Quang PT
Would it be just:
Formula:
Please Login or Register to view this content.
Best Regards,
Kaper
thefencegirl... is there a mistake in your original post? can you check your B6s and C6s to make sure you've asked your question correctly?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Thanks all for your help and so quickly, I was so close.. too many things on my plate today!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks