| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count if array contains cells of a certain value | Excel Worksheet Functions | |||
| How do I count the number of cells in a list, e.g. H6:H12, J4, J7: | Excel Worksheet Functions | |||
| Count # of cells b/w cells ... | Excel Discussion (Misc queries) | |||
| Count with Hidden cells | Excel Discussion (Misc queries) | |||
| how 2 Count number of cells that have specific condition format? | Excel Worksheet Functions | |||
Linear Mode
