Forum Discussion
Returning a value based on multiple criteria - SUMIF
Hi, I'm trying to return a value only if date criteria are satisfied, and I'm struggling to do this using the SUMIFS formula. I'm an ok excel user but I don't often have a need to use functions b...
=IF(AND(D2>=$B$2,D2<=$B$3),$B$1/(DATEDIF($B$2,$B$3,"m")+1),0)This returns the expected result if i correctly understand what you want to do.