Sum color cell that met given criteria

[Closed]
Report
-
Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
-
Hello,

can someone help me please, I need to count the cell with color that meet the given criteria...i.e. I have two sheet-one for stages of shops of each respective staff and 2nd is for summary. In one sheet firts name of staff then second column is the stage when complete you enter the dates and color the cells.Each staff handle 10 shops. I want to know if how many shop out of 10 for each staff have complete the first stage.



1 reply

Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
486
Hi Jonah,

See my example and let me know if I understood you correctly:

Jan	1-11-2010
Jan	8-11-2010
Jan	
Piet	
Jan	6-11-2010
Piet	5-11-2010

First column contains first names (A1:A6).
Second column contains dates when stage is compete (B1:B6).

You would like to know how many stages are complete (dates have been entered) per name.

Use the following formula to determine how many stages Jan completed:
=SUM((A1:A6="Jan")*(B1:B6<>""))
This is an array formula and needs to be confirmed by hitting Ctrl+Shift+Enter. Brackets ( {} ) around the formula will appear when done correctly.

Best regards,
Trowa