Results 1 to 10 of 12

Thread: Sumproduct Formula To Sum Range With Criteria On Numeric Text

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 04-06-2013, 03:24 PM #1
    Howardc
    Howardc is offline
    Senior Member
    Join Date
    Apr 2012
    Posts
    193
    Rep Power
    14

    Sumproduct Formula To Sum Range With Criteria On Numeric Text

    I have numbers in Col F and values in Col H on sheet1. I am trying to add values in Col H where the range of numbers is from 3000 to 3015.

    I have set up a sumproduct formula on Sheet 2 -The formula returns an incorrect value see A2. I have shouwn what the correct value should be in Cell C2

    Attached please find sample data

    It would be appreciated if you could assist & amend the formula so that it returns the correct answer
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Sum Of The Digits Of Numeric Value In A Cell Range
    By Zaigham in forum Excel Help
    Replies: 8
    Last Post: 04-29-2013, 08:36 PM
  2. Excel Formula To Check If All Characters Are Text Non-Numeric
    By NITIN SHETTY in forum Excel Help
    Replies: 10
    Last Post: 12-10-2012, 11:28 PM
  3. Sum Ifs Formula needed with Max Date range
    By trankim in forum Excel Help
    Replies: 2
    Last Post: 09-19-2012, 09:50 AM
  4. SUMIF With Multiple Criteria In The Same Column Criteria Range
    By Howardc in forum Excel Help
    Replies: 4
    Last Post: 08-11-2012, 10:50 PM
  5. Align all text in Left and all numeric values in center in a given range using vba.
    By LalitPandey87 in forum Excel Help
    Replies: 2
    Last Post: 02-29-2012, 08:24 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