Hello,
How do you build a column that can sum only the numbers for an overall total, and if there are no numbers, simply list the first value in PD1 as the total? I have three columns that can include both numbers and strings.
Thank you
Solved! Go to Solution.
@Arno_M I'm sure they are better ways to achieve this but see if this works for you.
Thank you! Worked out great.
User | Count |
---|---|
109 | |
92 | |
78 | |
54 | |
40 |