Forum Discussion
formula to give sample number of a certain sample type and on a certain day
Good afternoon, I need some help with a formula I want to use. I am trying to put together a formula that gives me a number if some conditions are met. The example excel is as follows: Produ...
It is possible to achieve the desired result without using macros.
You can use the COUNTIFS function in Excel to count the number of samples for each product on a given day.
Here’s an example formula that you can use in cell D2 and then drag down to fill the rest of the column:
=COUNTIFS(A$2:A2,A2,B$2:B2,B2)
This formula counts the number of rows in column A (Productsample) that match the current row’s product and have a date in column B (Date) that matches the current row’s date.
The result is the number of samples for that product on that day up to and including the current row.
See the file!
I hope this helps!