Sep 24 2020 04:15 AM - edited Sep 24 2020 04:16 AM
Dear All
Please help
Column F3 Formula : =COUNTIF(C3:C14;"Positive")
Column F4 Formula : I tried with the formula.....'=IF(NOW();COUNTIF(C3:C14;"Positive"))
For example …..
today input data until serial number 6 (yellow color)
tomorrow and the following days enter new data for serial numbers 7 to 12 and so on (green color)
how is the formula in column F4 of the daily report, where when the daily data input (in green) does not accumulate with the previous daily report (yellow)
Thank you so much for your help
Sep 24 2020 05:46 AM
Add a column (for example column D) in which you register the date.
You can then use a formula such as
=COUNTIFS(C3:C14;"Positif";D3:D14;TODAY())
Sep 24 2020 07:17 AM
Thank you so much for your help