ExcelBanter - Count cells with condition

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Count cells with condition (https://www.excelbanter.com/excel-worksheet-functions/44673-count-cells-condition.html)

Amanda

Count cells with condition

I need to count the number of cells in Column D that contain a date (or is
not blank) AND Column C contains "Amanda" in the same row.

I had it (by trial and error) and cannot recreate.
Please help.

JE McGimpsey

One way:

=SUMPRODUCT(--(D1:D1000<""),--(C1:C1000="Amanda"))

In article ,
Amanda wrote:

I need to count the number of cells in Column D that contain a date (or is
not blank) AND Column C contains "Amanda" in the same row.

I had it (by trial and error) and cannot recreate.
Please help.

edg

Count cells with condition

Thank you, thank you - you've also solved my problem
--
edg

"JE McGimpsey" wrote:

One way:

=SUMPRODUCT(--(D1:D1000<""),--(C1:C1000="Amanda"))

In article ,
Amanda wrote:

I need to count the number of cells in Column D that contain a date (or is
not blank) AND Column C contains "Amanda" in the same row.

I had it (by trial and error) and cannot recreate.
Please help.

All times are GMT +1. The time now is 01:10 PM.