Check 3 cells for values

[jmaty23]

I am trying to check 3 different cells for a number greater than 0. If any 2 of the 3 cells has a value greater than 1, I want to display "Duplicate" in a cell.

 

[Willmonbo]

can you be more specific as to what you're trying to get done, what ranges are you working with, and when you say duplicate what exactly do you want excel to do?

 

[jmaty23]

I am checking for redundant parts inventory between 3 different part rooms. Each part room represents a different cell (Part room 1=B5, Part room 2=C5,Part room 3=D5).

If B5 and C5 show a value greater than 0, I want a cell to show "Duplicate" as the value. The same is B5 and D5 show a value greater than 0, or if C5 and D5 show a value greater than 0.

 

[jmaty23]

Also if all 3 cells show a value greater than 0, I want "Duplicate" to show in a cell.

 

[Jonmo1]

Try

=IF(COUNTIF(B5:D5,">0")>1,"Duplicate","")

 

[Willmonbo]

if I understand you correctly try using the following formula in any cell of your choice perhaps E5

=IF(Sum(B5:D5)>=2, "Duplicate","")

let me know if it works.

 

[jmaty23]

Perfect Thank You!

 

[jmaty23]

Is there a way to count how many cells say "Duplicate" in a column and show the total in a cell?

 

[Jonmo1]

Try countif

=COUNTIF(A1:A1000,"Duplicate")