My Range is R:R and my criteria is A:A
Thanks
Code: Select all
.FormulaR1C1 = "=countif(RC18,""=""&RC1)"R1C1 Countifs
-
JoeExcelHelp
- 5StarLounger
- Posts: 1177
- Joined: 22 Jul 2013, 18:29
R1C1 Countifs
What am i doing wrong?
My Range is R:R and my criteria is A:A
Thanks
My Range is R:R and my criteria is A:A
Thanks
-
HansV
- Administrator
- Posts: 78446
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: R1C1 Countifs
RC18 is a single cell: the cell in column R in the same row as the cell with the formula. Column P is just C18:
Code: Select all
.FormulaR1C1 = "=COUNTIF(C18,""=""&RC1)"Best wishes,
Hans
Hans