SOLVED
How do you sum multiple columns w/ string & number values into a total
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Arno_M
6 - Meteoroid
‎01-26-2024
09:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
- Labels:
- Behavior Analysis
- Developer
3 REPLIES 3
MilindG
12 - Quasar
‎01-26-2024
10:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Arno_M I'm sure they are better ways to achieve this but see if this works for you.
12 - Quasar
‎01-26-2024
10:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎01-26-2024
01:23 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you! Worked out great.
