+ Reply to Thread
Results 1 to 6 of 6

Sum.IF formula with criterias ;)

Hybrid View

  1. #1
    Registered User
    Join Date
    01-13-2016
    Location
    Denmark
    MS-Off Ver
    2010
    Posts
    21

    Sum.IF formula with criterias ;)

    Hi

    I have a problem with a formula (SUM.IF) (Please note long formula

    There are som dirrent criterias

    I have uploadad the file here:

    Would be very very happy to get this solved

    Have a nice weekend,
    Last edited by JBeaucaire; 02-20-2016 at 02:31 PM.

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Sum.IF formula with criterias ;)

    I have removed the link to another site for the down load. Please upload your file here in the thread.

    EDIT post #1, then GO ADVANCED and use the paperclip icon.

    ===========


    I can tell you now that SUMIF() only allows a single criteria.

    But SUMIFS() allows multiple criteria, read the help files in Excel on that function.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    01-13-2016
    Location
    Denmark
    MS-Off Ver
    2010
    Posts
    21

    Re: Sum.IF formula with criterias ;)

    Hi

    Thanks for the reply..

    I know I can upload here, but it's not working. (Have tryied on 2 diffent machine)
    A blank box just shows up.

    See screendump here: http://i65.tinypic.com/hvt3di.jpg

    Kind regards

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Sum.IF formula with criterias ;)

    Quote Originally Posted by concepo View Post
    My internet security software blocks that link.


    McAfee WebAdvisor


    Warning: Trouble ahead


    Whoa!

    Are you sure you want to go there?

    http://i65.tinypic.com/hvt3di.jpg may be risky to visit.



    Why are you seeing this?

    When we visited this site, we found it exhibited one or more risky behaviors.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  5. #5
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Sum.IF formula with criterias ;)

    Perhaps turn on the Compatibility View in the Internet Explorer Compatibility View settings.

    http://screencast.com/t/LfZj4NTuv
    http://screencast.com/t/uBFqZeHWE

  6. #6
    Registered User
    Join Date
    01-13-2016
    Location
    Denmark
    MS-Off Ver
    2010
    Posts
    21

    Re: Sum.IF formula with criterias ;)

    Thanks, but it did't help
    Just a blank box

+ 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] Help with two Criterias Formula
    By odoualex in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-12-2015, 10:22 AM
  2. One Formula Searching for 2 Criterias
    By juicypeanut in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-10-2015, 12:54 AM
  3. [SOLVED] Match formula with different criterias
    By pezalmendra in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-28-2013, 05:05 PM
  4. [SOLVED] Countif formula with two criterias
    By masben in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-04-2013, 03:21 AM
  5. Formula with two/three criterias
    By angie.chang in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-28-2012, 05:02 AM
  6. IF and MAX in one formula but two criterias
    By Enviro1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-04-2006, 10:59 AM
  7. [SOLVED] Formula requiring two different criterias
    By MJMP in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-01-2005, 07:06 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