+ Reply to Thread
Results 1 to 6 of 6

Sumproduct when a letter is interrupting the data

  1. #1
    Registered User
    Join Date
    08-21-2020
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    30

    Sumproduct when a letter is interrupting the data

    Hi All,

    I hope you're all having a good week, I need some help with sumproduct, I'm trying to multipy one row of data by another, but i have letters within my data that i can't remove, please can someone help as i'm getting a value error.

    Kind Regards,

    Tom
    Attached Files Attached Files
    Last edited by TDFrench; 10-21-2020 at 06:57 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    04-27-2015
    Location
    Abu Dhabi, U.A.E
    MS-Off Ver
    Office 365 | 2016
    Posts
    696

    Re: Sumproduct when a letter is interrupting the data

    Please upload a sample workbook.

  3. #3
    Registered User
    Join Date
    08-21-2020
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    30

    Re: Sumproduct when a letter is interrupting the data

    Example now uploaded, :D

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Sumproduct when a letter is interrupting the data

    Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

    To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.

    My version of Excel doesn't mind if there are alpha characters in one of the sumproduct ranges, it just ignores them. Perhaps you mean you have alpha and numeric values in a single cell, but seeing the workbook will explain that
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  5. #5
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Sumproduct when a letter is interrupting the data

    Use instead

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    08-21-2020
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    30

    Re: Sumproduct when a letter is interrupting the data

    I always forget about the comma, thank you very much though Richard. much appreciated :D

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] SUMPRODUCT when cell contains letter
    By thisiscrazy in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-24-2016, 05:10 PM
  2. [SOLVED] SUMPRODUCT - Letter by Date range by Cell Value
    By Matt1998 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-21-2015, 11:13 AM
  3. Interrupting code
    By excelbobabc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-23-2010, 10:46 AM
  4. Interrupting Procedure Without Exiting?
    By Timmy Mac1 in forum Excel General
    Replies: 6
    Last Post: 12-22-2006, 09:43 AM
  5. [SOLVED] Interrupting initializing stage
    By Maxi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-14-2006, 08:30 AM
  6. Interrupting a Loop
    By Maxi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-25-2006, 02:15 PM
  7. Interrupting A Worksheet Calculation
    By carl in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-22-2005, 03:18 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