+ Reply to Thread
Results 1 to 3 of 3

sumif with 2 conditions

  1. #1
    Registered User
    Join Date
    09-05-2010
    Location
    italy
    MS-Off Ver
    Excel 2018
    Posts
    63

    sumif with 2 conditions

    Hi,
    I need to sum an array conditioned to two criteria.

    Example:
    I need the sum of all bills that are still pending and expiring same day.

    please see dummy file attached.

    thank you very much.

    Carlo
    Attached Files Attached Files
    Last edited by kghisla; 12-08-2010 at 06:37 PM.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,053

    Re: sumif with 2 conditions

    Here, try this:

    =SUMPRODUCT(--($D$3:$D$11="P"), --($C$3:$C$11=A19), $B$3:$B$11)
    Never use Merged Cells in Excel

  3. #3
    Registered User
    Join Date
    09-05-2010
    Location
    italy
    MS-Off Ver
    Excel 2018
    Posts
    63

    Re: sumif with 2 conditions

    It works, thank you very much Zbor!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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