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...
bvjsdfkv1690 I don't think you can do that with a Sumifs, but it's possible with a Sumproduct, so there will be no duplicate sums.
=SUMPRODUCT(AX3:AX433,--(((BK3:BK433>$CN$3)*(BK3:BK433<$CN$4))+((BV3:BV433>$CN$3)*(BV3:BV433<$CN$4))>0))
Perfect, thanks for your help