View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
peter peter is offline
external usenet poster
 
Posts: 4
Default Shannon diversity index formula

This function still evaluates to a #NUM error.

On Apr 8, 2:22 pm, Barb Reinhardt
wrote:
Try this

=-SUMPRODUCT(--(C2:C200),(C2:C20/SUM(C2:C20)),(LOG(C2:C20/SUM(C2:C20))))