Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Excel formula question

Sep 2, 2010 7:15AM PDT

I'm trying to set up a formula in excel for the following;
-I'll be entering in random alphanumeric codes in cells
-I need to add these codes up simply if there is ANY data in the cell
-For instance if I have 3 cells with any data in them, I need to sum this up as 3. Possible?

Discussion is locked

- Collapse -
Re: counting
Sep 2, 2010 7:25AM PDT
- Collapse -
Thank you
Sep 2, 2010 7:36AM PDT

THANK YOU! Great information Kees, appreciated.