Forum Discussion
Al_ns
Aug 30, 2022Copper Contributor
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")