Thread: How do i use sumproduct if my lookup table is alpha or alpha num?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Angie Angie is offline
external usenet poster
  
Posts: 79
Default How do i use sumproduct if my lookup table is alpha or alpha num?

Can I use sumproduct formula if my table is as follows ?

Yr End Rating
Mid Yr Rating A B C D
A same 1 down 2 down 3 down
B 1 up same 1 down 2 down
C 2 up 1 up same 1 down
D 3 up 2up 1 up same


Reply With QuoteReply With Quote