Sum color cell that met given criteria
Closed
Jonah
-
Nov 10, 2010 at 02:40 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 11, 2010 at 09:49 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 11, 2010 at 09:49 AM
Related:
- Sum color cell that met given criteria
- Notepad++ change background color - Guide
- Rj45 color - Guide
- Powertoys color picker - Download - Other
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
- If cell contains specific text then return value in another cell ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Nov 11, 2010 at 09:49 AM
Nov 11, 2010 at 09:49 AM
Hi Jonah,
See my example and let me know if I understood you correctly:
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
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
