LinkBack URL
About LinkBacks
I have tried to set up sumifs formula to extract values based on a range of dates for a particular month for eg from 01/03/2020 to 31/03/2020 for all values pertaining to March 2020
However, my formula returns zero
Kindly check and amend my formula
I have tried to set up sumifs formula to extract values based on a range of dates for a particular month for eg from 01/03/2020 to 31/03/2020 for all values pertaining to March 2020
However, my formula returns zero
Kindly check and amend my formula
Try this in E2 and drag down
=SUMIFS(B:B,A:A,">="&F2,A:A,"<="&G2)
Happy with my advice? Click on the * reputation button below
Alternative formula
Formula:
=SUMPRODUCT($B:$B,($A:$A>=F3)*($A:$A<=G3))
Hi Crooza & Shareez
Many thanks for the help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks