Help with counting in Excel with a condition
Closed
Jilly
-
7 May 2010 à 09:48
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 7 May 2010 à 10:16
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 7 May 2010 à 10:16
Related:
- Help with counting in Excel with a condition
- Count occurrences in excel - Guide
- Counting names in excel - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Arrow keys not working in excel - Guide
- Excel vba send email with attachment - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
7 May 2010 à 10:16
7 May 2010 à 10:16
Try this
=IF(SUMPRODUCT(1 * (A1:A50 =""))+ SUMPRODUCT(1 * (A1:A50<>""))=SUMPRODUCT(1 * (A1:A50 ="")), "X", COUNTA(A1:A50))
=IF(SUMPRODUCT(1 * (A1:A50 =""))+ SUMPRODUCT(1 * (A1:A50<>""))=SUMPRODUCT(1 * (A1:A50 ="")), "X", COUNTA(A1:A50))
