LinkBack URL
About LinkBacks
Hi kri54sub
Try the SUMPRODUCT as you uploaded a xls file.
In E8 copy across and down:
Formula:
=SUMPRODUCT(($A$4:$A$13=$D8)*($B$4:$B$13=E$7))
Hi kri54sub
Try the SUMPRODUCT as you uploaded a xls file.
In E8 copy across and down:
Formula:=SUMPRODUCT(($A$4:$A$13=$D8)*($B$4:$B$13=E$7))
Regards Kevin
Merged Cells (They are the work of the devil!!!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks