Hi,
=IF(Evaluation!$C$27=1,SUMPRODUCT(--(INDEX($O$6:$V$2000,0,MATCH($BX6,$O$4:$V$4,0))=BY$5&"Y")))
=IF(Evaluation!C27=3,SUMPRODUCT(--($E$6:$E$2000-DAY($E$6:$E$2000)+1=EOMONTH(Evaluation!$C$29,-1)+1),--(INDEX($O$6:$V$2000,0,MATCH($BX6,$O$4:$V$4,0))=BY$5&"Y")))
First formula is reading the values without checking the month(C27=1 entire range), and second the formula C27 cell is 3 then it check for individual month wise, is there any way to add the above two formulas
Both formulas are working fine with one if statement, both should work based on C27 value
Regards
Sagar
Bookmarks