Increment cell value depending on input elsewhere

**Waidesworld** · 08-30-2007, 10:27 AM

I have an ongoing list of RMA complaints, 11 in total. I want to know if I add a description in a column like "Wrong Part Shipped" the the WPS tally increments by one. I have one column with all the reasons for material returned.

Thanks

**Ron Coderre** · 08-30-2007, 10:42 AM

Perhaps something like this...

With Col_B containing RMA reasons

D2: Wrong Part Shipped

This formula returns the number of cells containing "Wrong Part Shipped":
E2: =COUNTIF(B:B,"*"&D2&"*")

Note: I used the wildcard version in case more that one reason can exist in a cell.
Example: Damaged, Wrong Part Shipped, Wrong Color

If that cannot occur, then use
E2: =COUNTIF(B:B,D2)

Does that help?

**Macdave_19** · 08-30-2007, 10:42 AM

Hey dude i think i will be able to help but your not very clear. please uplaod the file so i can see what you mean.

i think you'll just need to use a

=COUNTIF(A:A,"Wrong Part Shipped")

this should count the number of times it shows within the column A