SUMIF not Iffing

[Wanna Learn]

Hello this is the formula I created
=SUMIF(Raw!A1361,Raw!C1=Fax,Raw!D1361) 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

 

[Don Guillett]

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)

 

[Gaurav]

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

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

 

[FSt1]

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