Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Exceln00b
  • Content: Threads
  • Order by date
  1. Exceln00b

    Excel Sumproduct Query

    can someone tell me if this is a wrong usage? =IF(B6="EM";SUMPRODUCT(--(E8='[Raw Data.xls]Sheet1'!$I:$I)+('[Raw Data.xls]Sheet1'!$CX:$CX="10"));SUMPRODUCT(--(B6='[Raw Data.xls]Sheet1'!$L:$L)*--(E8='[Raw Data.xls]Sheet1'!$I:$I)*--('[Raw Data.xls]Sheet1'!$CX:$CX="10"))) It returns a #num! value...

Part and Inventory Search

Back
Top