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. #1
    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

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1