View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Further Excel help for =SUMPRODUCT((C$1:E$8=G1)*B$1:B$8)

A good resource for SUMPRODUCT()

http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
Gary''s Student - gsnu200784


"MikeR-Oz" wrote:

Any one able to assist with formulae like the above which for me is quite
advanced yet I am sure it is intermediate.

I would like to attach a file to give as n example of what I am trying to
do. (How do I do this on the newsgroup?)

Have already got this far from an Excel MVP help and need to expand what I
am doing with a roster.

Any takers??

Mike