Count over Multiple columns, please help

**theGHB** · 03-08-2013, 08:41 AM

Screen shot 2013-03-08 at 12.38.17.png
Hi all,
Really struggling here, what I need is to be able to count which species appear in similar sites e.g. Shallow,Plastic and Horizontal, without counting the same species multiple times. Is this possible, can someone help me?

Thanks in advance,
George

**Pepe Le Mokko** · 03-08-2013, 09:04 AM

Hi nice picture
Please post a sample sheet. Much more useful

**dilipandey** · 03-08-2013, 09:08 AM

Hi George,

welcome to the forum.
Please upload a sample excel workbook, not image.. thx

Regards,
DILIPandey
<click on below * if this helps>

**theGHB** · 03-08-2013, 09:11 AM

Copy of Settlement_data_2013.xlsx
There you go guys, sorry about that
Cheers

**dilipandey** · 03-08-2013, 09:16 AM

Hi George,

Only 4 sepcies are repeating in column D:-
Ceramium rubrum
Pomatoceros triqueter
Pterothamnion plumula
Unidentified sp.

what is your expected result ?

Regards,
DILIPandey
<click on below * if this helps>

**theGHB** · 03-08-2013, 09:26 AM

i want to be able to count the number of individual species that occur in each treatment for example columns E,M,N,W,Y(Shallow,PLastic,Horzontal) without counting the same species more then once.
Thanks,
G

**dilipandey** · 03-08-2013, 09:30 AM

sorry... m not getting it.

Can you share your expected results - manually entered and I'll try to obtain them using formulas.. thx

Regards,
DILIPandey
<click on below * if this helps>

**theGHB** · 03-08-2013, 09:44 AM

ok so the bottom row is the total number of species in each treatment. I want this data for all the replicates combined but the only way i can manage to do it is by doing a count for each column which then means that i may have counted the same species multiple times. If I'm not making sense then don't worry i can do it manually its just there must be a way of doing it quickly.
Thanks anyway, really appreciate any help

**dilipandey** · 03-08-2013, 10:12 AM

by doing a count for each column which then means that i may have counted the same species multiple times.

As I shared earlier, there are only 4 species which can be counted more than 1 since all other are unique ones.

Regards,
DILIPandey
<click on below * if this helps>