Previous Topic Next Topic

Help with counting in Excel with a condition

Closed
Jilly - May 7, 2010 at 09:48 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 7, 2010 at 10:16 AM
Hi,
I would like Excel to count a range of non-blank cells and enter the number but if all the cells in the range are blank, I'd like it to fill in with an "x". Is this possible?
Thanks
Jilly
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 7, 2010 at 10:16 AM
Try this

=IF(SUMPRODUCT(1 * (A1:A50 =""))+ SUMPRODUCT(1 * (A1:A50<>""))=SUMPRODUCT(1 * (A1:A50 ="")), "X", COUNTA(A1:A50))

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses