Thread
:
Shannon diversity index formula
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
peter
external usenet poster
Posts: 4
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))))
Reply With Quote
peter
View Public Profile
Find all posts by peter