Results 1 to 5 of 5

Modify Equation

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-22-2012
    Location
    Narragansett, Rhode Island
    MS-Off Ver
    Excel 2007
    Posts
    122

    Modify Equation

    Hi

    I have been working on analyzing the performance of a group of organizations. As you will note from the attached worksheet, I have used the equation =SUMPRODUCT(--($D$2:$D$150000>=H1),--($D$2:$D$150000<=I1),(($E$2:$E$150000 ="0100")+($E$2:$E$150000 ="0200")), $F$2:$F$150000) to identify the total for all organizations reporting expenses on, for example, line 00100-00149, column 0100 and 0200. I would like to modify the equation to select the 00100-00149, column 100 and 200 values for a specific organization. It seems to me that I have to add an additional identifier (org #) to get this value.

    Thanks for your help.

    Al
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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