Attached is a file where I have sales listed out by month for 2013 and 2014. In N2, I would like a formula telling it to sum only the months where there is a total for those months in 2014. So, it would currently add Oct thru Aug, leaving off Sept 2013 because there is no total entered for Sept 2014. Plus, I would like M4 for be blank because there is no total entered in Sept 2014. Thank for your help.
Using your posted workbook
This formula sums 2013 cells where the corresponding 2014 cell is greater than 0
And this formula, copied across, calculates the percent difference
N2: =SUMIF(B3:M3,">0",B2:M2)
Is that something you can work with?B4: =IF(COUNTIF(B2:B3,">0")=2,(B3-B2)/B2,"")
Perfect, thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks