Forum Discussion

Al_ns's avatar
Al_ns
Copper Contributor
Aug 30, 2022
Solved

Countif? (SOLVED)

I am trying to build a counter that uses one cell for the criteria but actually counts the value in another cell. I almost have it working. The spreadsheet I am using to program kitchen cabinet parts inserts lines at the top of the sheet as more parts are added. I am trying to get it to count the number of a specific shelf for a job. The shelf name is on the sheet "kitchen" in column B and the number of shelves in Column E line 20.

=COUNTIF(Kitchen!A:B,"uppershelf.bpp")

returns a 1 for there being the right type of shelf but I cant figure out how to get it to calculate to correct number of shelves

 

 

 

  • Maybe you want =SUMIFS(Kitchen!E:E, Kitchen!B:B, "uppershelf.bpp")

Resources