Results 1 to 5 of 5

Sumproduct with month, year, other criteria, and blank

Threaded View

bibbi2 Sumproduct with month, year,... 04-29-2015, 12:10 AM
FlameRetired Re: Sumproduct with month,... 04-29-2015, 12:31 AM
azumi Re: Sumproduct with month,... 04-29-2015, 12:32 AM
benishiryo Re: Sumproduct with month,... 04-29-2015, 12:34 AM
bibbi2 Re: Sumproduct with month,... 04-29-2015, 12:47 AM
  1. #1
    Registered User
    Join Date
    10-25-2013
    Location
    ina
    MS-Off Ver
    Excel 2010
    Posts
    8

    Sumproduct with month, year, other criteria, and blank

    Hi all,

    I have problem with sumproduct please help me, I'm really stuck..

    My data is attached. I want to search coal ABC sum value based on the date on B5.

    My attempt: =SUMPRODUCT(($L$4:$L$13),($K$4:$K$13="ABC")*(MONTH($M$4:$M$13=B3))*(YEAR($M$4:$M$13=B4)*($M$4:$M$13<>"")))---> failed.

    Thanks in advance guys!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 18
    Last Post: 09-08-2014, 05:06 PM
  2. [SOLVED] Sumproduct from date - 4 criteria (inc month & year)
    By Knawl in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-28-2014, 04:48 AM
  3. Using SUMPRODUCT For Two Criteria AND Month of Year.
    By stuu3270 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-16-2013, 06:22 AM
  4. [SOLVED] SUMPRODUCT, OR, Less than Month & Less than Year
    By JUGGAKNOTZZ in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 03-01-2013, 10:51 AM
  5. SumProduct error when using Year , Month and text criteria
    By jsrobin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-11-2008, 10:56 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