Results 1 to 8 of 8

How to count and sum of numbers separated by comma in multiple cells of a row in excel?

Threaded View

pareshkumarparekh How to count and sum of... 09-16-2020, 03:19 AM
bebo021999 Re: How to count and sum of... 09-16-2020, 04:31 AM
XOR LX Re: How to count and sum of... 09-16-2020, 04:44 AM
bebo021999 Re: How to count and sum of... 09-16-2020, 06:06 AM
XOR LX Re: How to count and sum of... 09-16-2020, 06:31 AM
pareshkumarparekh Re: How to count and sum of... 09-16-2020, 08:39 AM
bebo021999 Re: How to count and sum of... 09-16-2020, 09:18 PM
pareshkumarparekh Re: How to count and sum of... 09-17-2020, 05:16 AM
  1. 09-16-2020, 03:19 AM #1
    pareshkumarparekh is offline
    Registered User
    Join Date
    06-14-2020
    Location
    India
    MS-Off Ver
    2010
    Posts
    7

    How to count and sum of numbers separated by comma in multiple cells of a row in excel?

    I am attaching here one excel file in which I want to count and sum of numbers seperated by comma in multiple cells of one row.

    In Z9 cell I want to count all values seprated by comma in Row 9 but given in "Visit" columns.

    In AA9 cell I want to count all values seprated by comma in Row 9 but given in "Tel" columns.

    In Z10 cell I want to sum all values seprated by comma in Row 10 but given in "Visit" columns

    In AA10 cell I want to sum all values seprated by comma in Row 10 but given in "Tel" columns.

    Thanks and Regards,

    Pareshkumarparekh
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Graphing data from multiple cells each containing varying amounts of comma separated value
    By ride_op in forum Excel General
    Replies: 11
    Last Post: 09-16-2020, 09:38 PM
  2. Average of comma separated numbers from multiple cells
    By engineer_infinity in forum Excel General
    Replies: 7
    Last Post: 04-03-2020, 04:48 PM
  3. [SOLVED] count and category comma separated numbers.
    By sathi87 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-10-2018, 07:04 AM
  4. count unique comma separated names in range of cells
    By raogm2001 in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 10-07-2017, 09:50 AM
  5. Separating multiple data separated by a comma into single cells.
    By sgmgrider in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-29-2015, 05:58 PM
  6. [SOLVED] Counting number of occurrences in cells with numbers separated by a comma
    By Losguapos1 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-02-2013, 09:44 AM
  7. [SOLVED] Count comma separated numbers, numbers in a range with dash, not t
    By Mahendra in forum Excel General
    Replies: 0
    Last Post: 08-08-2005, 01:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1