Hi All,
I need your help due the sumproduct error when some of arrange no value.
Exmaple:
=SUMPRODUCT((Benetton!$B$2:$F$2=$B$5)*(Benetton!$A$3:$A$5=$A$4)*(Benetton!$B$3:$F$5))
==> B2:F5 ( some time row B2 blank and some time row B4 blank, then it make the formula error. Anyone please help on this.
I have attached file for your more detail.
in F3, change=IF(OR(E3="",D3=0),"",E3/D3) as =IF(OR(E3="",D3=0),0,E3/D3)
and copy towards down
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Hi, Try this
Formula:
Please Login or Register to view this content.
☚ Click ★ just below left if it helps, Boo?ath?
remember one thing while using sumproduct if you are matching for non numeric then match should be non numeric
and when you are taking sum at final instance the column/ row must contain numeric values
regards
Hi All,
Thanks for help and share.
Have a nice day.
Leakhna
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks