Thread
:
sumproduct
View Single Post
#
1
Posted to microsoft.public.excel.programming
RobcPettit[_2_]
external usenet poster
Posts: 108
sumproduct
Hi, could somebody explain why the '-' in
=SUMPRODUCT(-(F2:F14="S"),-(G2:G14<8)), make such a difference. Used
without, which I was doing until Iposted here earlier, doesnt return
the same results.
Regards Robert
Reply With Quote
RobcPettit[_2_]
View Public Profile
Find all posts by RobcPettit[_2_]