Hello, I have the following problem. I am trying to calculate the table "from the bottom" (I do not mean one single result), so that the program has to search for a given product, eg code 1111 from column B and in the range of obtained results count how many defects have occurred marked with the letter "K" column C at 5 recent deliveries of this product from the bottom. I want to put a formula in column D. I tried with countifs and combined formula countif with if. This second solution was close
= IF (COUNTIF (B29: B100; B29); COUNTIFS (B29: B36; B29; C29: C36; C29); 0) "However, in the second part, the formula counted from the cells found in the entire range and not only from those for the product 1111.
The database is huge. The attached file is just a simplified example. Ideally, it would be if I could change the range of the last 10, a reference to the cell where I could freely change it. In the example, I just set the range in the formula for the last 5 lines.Produkt 1111 1.jpgProdukt 1111.jpg
Bookmarks