Abundance & Species Richness-- Accumulating Problems

[dr_v]

Hello, and thank you in advance for assistance.

I have species abundance data (columns) by sample (rows) in an Excel spreadsheet, and am interested in summarizing it as accumulated species richness. I used a "countif" (e.g., countif(B1:B13, ">0") function to summarize species richness by sample. Does anyone have a function for accumulated species richness as I increase sample number (how many new species do I add with each additional sample)?

[oeldere]

Probably with sumproduct.

Other option should be:

Pivot table.