Hi Papaku,

Try this

=IF(COUNT(A2:G2)>0,COUNT(A2:G2) & " trainings completed", "No training completed to date")

regards

Phil

I have seven cells in a row. I am trying to count the number of cells with a date, text or anything written on them.

The complication for me is I'm trying to figure out if its possible to provide a count of how many cells are not blank and add a concatenation at the end.

For example: <span data-sheets-value="{"1":2,"2":" https://omegle.onl/ vshare"}" data-sheets-userformat="{"2":513,"3":{"1":0},"12":0}"> https://omegle.onl/ vshare

For the range of A2:G2, any 3 cells would have a date and cell H2 would have a summary indicating "3 trainings completed"

If the cells in this range are all blank, i would like H2 to simply say "No trainings Completed to date"

I got this,...