Results 1 to 3 of 3

Help on IF Formula evaluating multiple criteria

Threaded View

  1. #1
    Registered User
    Join Date
    02-03-2009
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2003
    Posts
    11

    Help on IF Formula evaluating multiple criteria

    Ok, I'm having brainfreeze right now and cannot remember how I got this to work. Below is a formula from another workbook I'm currently using that works as intended:

    {=SUM(IF($D$4:$D$5000=L6,IF($E$4:$E$5000=1,1,0)))}

    My only question is HOW I got those outer brackets around the formula to get it to work. I can't recall the term used for this type of formula and my attempts at using the Excel Help menu to find the answer weren't successful. Thanks in advance!
    Last edited by manzano16; 09-10-2010 at 12:58 PM.

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