Results 1 to 7 of 7

SUMPRODUCT or SUMIF Formula Help Please

Threaded View

reddaze SUMPRODUCT or SUMIF Formula... 03-01-2017, 08:00 AM
Glenn Kennedy Re: Formula Help Please 03-01-2017, 08:03 AM
Phuocam Re: SUMPRODUCT or SUMIF... 03-01-2017, 08:10 AM
reddaze Re: SUMPRODUCT or SUMIF... 03-01-2017, 08:19 AM
Phuocam Re: SUMPRODUCT or SUMIF... 03-01-2017, 08:23 AM
reddaze Re: SUMPRODUCT or SUMIF... 03-01-2017, 08:25 AM
Phuocam Re: SUMPRODUCT or SUMIF... 03-01-2017, 08:27 AM
  1. #1
    Registered User
    Join Date
    02-14-2014
    Location
    Halesowen, England
    MS-Off Ver
    Excel 2016
    Posts
    45

    SUMPRODUCT or SUMIF Formula Help Please

    ITEM MEMBER QTY FROM

    888556 FRED 10 UK
    887223 BOB 22 FRANCE
    775223 KEV 3 SPAIN
    888776 FRED 50 USA
    888224 FRED 28 UK


    I have attached the actual sheet also, but what I need to find out using the above data, is how many items, that start with 888 has Fred got for the UK?

    I have already tried SUMPRODUCT and variations of COUNTIFS, but I have too much criteria to match

    Thanks in advance
    Attached Files Attached Files
    Last edited by reddaze; 03-01-2017 at 08:05 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel formula bar to display the result of the formula , not the formula?
    By max_max in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-18-2016, 07:15 PM
  2. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  3. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 PM

Tags for this Thread

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