Help with counting in Excel with a condition [Closed]

Question

Help with counting in Excel with a condition [Closed]

Report

Jilly - May 7, 2010 at 09:48 AM
rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

- 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

Help with counting in Excel with a condition
Excel - Copy if condition range is met - How-To - Excel
How to count in excel by name - How-To - Excel
Excel remove all conditional formatting from workbook - How-To - Excel
Count formula excel french - How-To - Excel
If statements in excel with multiple conditions - How-To - Excel

1 reply

Ask a question

rizvisa1 · Answer 1 · 2010-05-07T10:16:00-0400

Answer 1 / 1

rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

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))

Help with counting in Excel with a condition [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!