Excel help please

Giddytimes

Hoping there is an Excel guru online this evening as my spreadsheet is driving me potty.

I need a formula which will count the number of populated cells in column E if the date in column C is between the range specified in F3 and G3.

I've been trying variations of Counta, Countif etc with no joy so far. Anyone have any ideas?

WTFH

Can you explain in English what you want to achieve as a final result - just wondering if the way you're going about it maybe isn't the best.

stevemcol

I would use a blank column which populates 'true' or '1' or similar if column 'c' in that row falls within the date range AND the row in colum E is populated. Then countif that new colunm for 'true' or whatever you used. Do you need more detail?

Mirno

=sum(e:e)-sumif(c:c,concatenate("<",$f$3),e:e)-sumif(c:c,concatenate(">",$g$3),e:e)

stevemcol

the OP was asking for a count not a sum.

TrickyDicky101

Giddytimes wrote: »

Hoping there is an Excel guru online this evening as my spreadsheet is driving me potty.

I need a formula which will count the number of populated cells in column E if the date in column C is between the range specified in F3 and G3.

I've been trying variations of Counta, Countif etc with no joy so far. Anyone have any ideas?

Looks like:

=COUNTIFS(E:E,"<>",C:C,">"&F3,C:C,"<"&G3)

The above assumes you do literally mean between the dates (ie not equal to either date (replace "<" with "<=" etc if so)) and that you are using at least xl2007