+ Reply to Thread
Results 1 to 5 of 5

Double IF Formula?

Hybrid View

  1. #1
    Forum Contributor Portuga's Avatar
    Join Date
    02-20-2004
    Location
    Portugal
    MS-Off Ver
    365
    Posts
    852
    Try:

    =SUMPRODUCT((A2:A1000="37")*(F2:F1000="VD")*G2:G1000)

    (I had "37" wrapped in inverted commas, because you have it formated as text)
    Last edited by Portuga; 04-14-2008 at 01:15 AM.
    If you found the solution to your question. Mark the thread as "Solved"
    Thank everyone that helped you with a valid solution by clicking on their

    There is no such thing as a problem, only a temporary lack of a solution

  2. #2
    Registered User
    Join Date
    04-10-2008
    Posts
    3
    That works great.
    Thanks a lot!

    Michael

+ Reply to Thread

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