if or sum

[Brendan]

i have a spread sheet ..

on the columns i have different species of fish,starting
in column D ( say fish 1 fish 2 fish 3 )


in the rows i have from C2 types of pollution, ( e. o. s.
r)


I trying to find a function to sum only the e's for fish
1 2 and 3

then the 0. S. etc


ive tried a few functions but not the best with Excel

 

[Guest]

If you would like to count the total number of instances of 'e' in a column, I would recommend using the 'countif' function. The syntax is: =countif(range,critera).

Hope this helps

Lis

Visit www.databasementsoftware.com - your source for shareware, tools, and utilities.

 

[Guest]

-----Original Message-----
If you would like to count the total number of instances

of 'e' in a column, I would recommend using the 'countif'
function. The syntax is: =countif(range,critera).

Hope this helps,

Lisa

Visit www.databasementsoftware.com - your source for

shareware, tools, and utilities.

.
lisa ... ive just tried the countif ...but i seem to be

entering to may arguments ... im realy not to sure how to
present the function ... this is what i am trying =countif
((C:C=E),sum(D),0) and even as i read it i know its
wrong. ...

 

[Frank Kabel]

Hi Brendan
Try the following for counting all 'e' for fish1:
=COUNTIF(C2:C1000,"e")

 

[brendan]

Frank,

Thanks im nearly there. i know my post a bit vauge.
I am tring to count the sum of column d, but say only if
there is an e in column c.

if you know what i mean, getting bit confuse myself

Thanks
Brendan

 

[Frank Kabel]

Hi Brendan
use SUMIF:
=SUMIF(C2:C1000,"e",D21000)

 

[Brendan]

Frank


Thank you ... works a treat.



Brendan

-----Original Message-----
Hi Brendan
use SUMIF:
=SUMIF(C2:C1000,"e",D21000)

--
Regards
Frank Kabel
Frankfurt, Germany
Excel .
.