Forum Discussion
Sumif help...
Hi, I need help with a sumif/sumifs formula... My formula currently looks like this: =SUMIFS(AX3:AX433,BK3:BK433,">"&$CN$3,BK3:BK433,"<"&$CN$4,BV3:BV433,">"&$CN$3,BV3:BV433,"<"&$CN$4) This...
You may try this Array Formula which requires confirmation with Ctrl+Shift+Enter instead of Enter alone.
=SUM(--(FREQUENCY(IF(AX3:AX433<>"",IF(OR(BK3:BK433>CN3,BV3:BV433<CN4),MATCH(""&AX3:AX433,""&AX3:AX433,0))),ROW($AX$3:$AX$433)-ROW($AX$3)+1)>0))
Remember to confirm it with Ctrl+Shift+Enter.