Results 1 to 4 of 4

Sumproduct basics

Threaded View

  1. #1
    Registered User
    Join Date
    05-19-2010
    Location
    Brazil
    MS-Off Ver
    Excel 2007
    Posts
    6

    Unhappy Sumproduct basics

    I am sorry to post again in another thread, I'm still getting used to the forum!

    I had a question about SUMIF, SUMIFS and SUMPRODUCT.
    Well, I could manage to work with SUMIFS, but now I have an urgent need to adapt it to OO, so I need SUMPRODUCT.

    I attached an Example of my DataSheet. It has SALES and the BREAKDOWN, where I basically put together a daily report!

    As you can see, on the BREAKDOWN Sheet I want to SUMIF the values of the SALES, but under the FORM OF PAYMENT criteria. I can do it easily with SUIMIF, but when I go to the next day e.g. 10/10/10 I have to use SUMIF again and manually declare the range of rows I want to include in the formula, and that really sux! I want to say WHEN ANY cells from the Column A from SALES matches the value of A2 (05/05/05 in the example), then SUMIF(RANGE 1;"CREDIT";RANGE 2), the regular SUMIF! This first condition is killing me! Can anyone help?

    Thank you!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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