Results 1 to 6 of 6

SumIf with more than one condition

Threaded View

qwyz SumIf with more than one... 05-12-2009, 08:00 AM
JONvdHeyden Re: SumIf with more than one... 05-12-2009, 08:04 AM
zbor Re: SumIf with more than one... 05-12-2009, 08:05 AM
DonkeyOte Re: SumIf with more than one... 05-12-2009, 08:52 AM
qwyz Re: SumIf with more than one... 05-12-2009, 09:56 AM
zbor Re: SumIf with more than one... 05-12-2009, 10:02 AM
  1. #1
    Registered User
    Join Date
    10-09-2008
    Location
    blah
    Posts
    7

    SumIf with more than one condition

    Hi, I'm trying create a Sum(If formula with 2 conditions, but whatever I try doesn't seem to want to cooperate. I want to add up the sum of all invoices according to the country they deal with and the month that they were created in. I've attached a sample file showing what I'm trying to accomplish.
    Here is how far I've gotten so far:
    =SUM(IF(Main!$L:$L;B21*Main!$Z:$Z;C20);Main!$H:$H)

    I've tried other forms as well but even though this only returns #Value!, at least the formula is accepted.

    Any help would be greatly appreciated!
    Attached Files Attached Files
    Last edited by NBVC; 05-12-2009 at 10:02 AM.

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