Counting sets in excel

I have made an inventory of our printer toners, i just want a formula to count if 4 cells have 1 of each then it should display 1 set and so on.


<!–td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}–>

HP LaserJet
125A Black 4  
125A Cyan 3  
125A Yellow 5  
125A Magenta 4  


I entered 3 because we only have 3 sets and the rest are extra. Please guide me what formula can count this.



By: altamash

Leave a Reply

Your email address will not be published. Required fields are marked *