Forum Discussion
Help Please: I need this to return the Sum not False
=IF(AND(B2>="7/1/2018"+0,B2<"7/8/2018"+0),SUM(W2:AJ2)) B2 is a Text Row W2-AJ2 are Numbers returns: FALSE I need it to return the sum. Any help is much appreciated!
Hi Jan, Thank you so much for responding. I had just figured out that I was missing the ELSE part when I got the notification.
However it is now returning a 0(zero) instead of the sum.
The dates have been converted to text and range from 7/1/2018-9/17/2018. I am attempting to group all dates 7/8/2018 and below in order to return a value from the selected row domain W2:AJ2.
Would my current formula not return the sum from the specified row domain based on the text contents in B2?
I can't thank you enough, this formula is the most complex I've worked with.
Loving the Learning,
Amber
I expect it is because cells W2:AJ2 don't really contain numbers. Highlight those cells and see if any "widget" pops up, if so click it and follow instructions.