Help.
I want to put these 2 formulas ino the same cell.
=(COUNTIF(R8:V28,"D")+COUNTIF(R8:V28,"N"))*2 and =(COUNTIF(R8:V28,"D")+COUNTIF(R8:V28,"N"))*1
Help.
I want to put these 2 formulas ino the same cell.
=(COUNTIF(R8:V28,"D")+COUNTIF(R8:V28,"N"))*2 and =(COUNTIF(R8:V28,"D")+COUNTIF(R8:V28,"N"))*1
It depends how you want to put them into a single cell...
Here is a way to "concatenate" them into a single cell:
=(COUNTIF(R8:V28,"D")+COUNTIF(R8:V28,"N"))*2 & (COUNTIF(R8:V28,"D")+COUNTIF(R8:V28,"N"))*1