Hello,
In the table below, in D2 what formula can I use to count the number of blank cells between L2 and S2 (which is when the user signed on as noted in columns B and C)?
and in D3 the formula should count the number of blank cells between F3 and M3.
So for User001, I would like to see 1 (as 2014 october is blank) and User002, there are 3 blank cells in F:M
I am using the countif formula =COUNTIF(E2:S2,"") but it is counting the entire range E:S and that is not what I want.
(I posted a similar posting earlier but I suspect it was too wordy and complex).
Any help would be appreciated.
nmss
In the table below, in D2 what formula can I use to count the number of blank cells between L2 and S2 (which is when the user signed on as noted in columns B and C)?
and in D3 the formula should count the number of blank cells between F3 and M3.
So for User001, I would like to see 1 (as 2014 october is blank) and User002, there are 3 blank cells in F:M
I am using the countif formula =COUNTIF(E2:S2,"") but it is counting the entire range E:S and that is not what I want.
(I posted a similar posting earlier but I suspect it was too wordy and complex).
Any help would be appreciated.
nmss
| Excel 2012 | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | |||
| 1 | User | Live Date | Cancel Date | Dormancy | 2014 January | 2014 February | 2014 March | 2014 April | 2014 May | 2014 June | 2014 July | 2014 August | 2014 September | 2014 October | 2014 November | 2014 December | 2015 January | 2015 February | 2015 March | ||
| 2 | User001 | 2014 August | 2015 March | 8 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||||||||||
| 3 | user002 | 2014 February | 2014 September | 10 | 1 | 1 | 1 | 1 | 1 | ||||||||||||
Sheet3 | |||||||||||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| D2 | =COUNTIF(E2:S2,"") | |
| D3 | =COUNTIF(E3:S3,"") | |
