try this idea to count the number of "fax" in col B
=COUNTIF(b2:b361,"fax")
if you have numbers in column c and want a total of col c where col b has
"fax"
=SUMIF(b2:b361,"fax",c2:c361)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Wanna Learn" wrote in message
...
Hello this is the formula I created
=SUMIF(Raw!A1:D361,Raw!C1=Fax,Raw!D1:D361) I get 0 What want to do is
get a total amount
of faxes that are in column C . Column B has the word fax (there are
other
words in the column but I'm only interested in the word "FAX") thanks