SUMIF not Iffing
 

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

SUMIF not Iffing
 

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

SUMIF not Iffing
 

why do you have column D and A in your formula? Try this.

=SUMIF(Raw!B1:B361,"Fax",Raw!C1:C361)



"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

SUMIF not Iffing
 

hi
are you summing or counting?
if summing the formula might work better like this.....
=SUMIF(Raw!B1:B361,"Fax",Raw!C1:C361) since column b contains the word fax
and column c contains the sum quantity.
if counting then
=countif(Raw!B1:B361,"Fax")
I'm not sure what quantites you may have in column C so i am guessing a
little.

Regards
FSt1

"Wanna Learn" wrote:

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