Thread: [Solved] Sumproduct formula
View Single Post
 
Old 09-12-2012, 07:45 AM
Portucale Portucale is offline Windows 7 32bit Office 2010 32bit
Novice
  
Join Date: Sep 2012
Posts: 3
Portucale is on a distinguished road
Default
Thanks guys,

Managed to get the solution...

Using excel 2003:

=SUM(INDEX((C2:C1000=147386)*(D21000=6)*A2:A1000 *B2:B1000,))/SUMPRODUCT(--(C2:C1000=147386),--(D21000=6),--(A2:A1000))
Using 2007-2010
=SUM(INDEX((C2:C1000=147386)*(D21000=6)*A2:A1000 *B2:B1000,))/SUMIFS(A2:A1000,C2:C1000,147386,D21000,6)

Or

=SUM(INDEX((C2:C1000=147386)*(D21000=6)*A2:A1000 *B2:B1000,))/SUM(INDEX((C2:C1000=147386)*(D21000=6)*A2:A1000, ))
Reply With Quote