• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Troubleshooting

#VALUE Using SUM(MONTH

When I use aSUM(MONTH formula, I get a#Value return.

Make sure you press Ctrl+Shift+Enter to activate the array, which is the multiple adjacent ranges the formula is referencing {=SUM((YEAR(B9:B15)=B20)*(MONTH(B9:B15)=C20)*(C9:C15))}.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint