Results 1 to 4 of 4

Exclude specific parameters in a column while using SUMIFS

Threaded View

Runnit4 Exclude specific parameters... 11-12-2009, 04:23 PM
daddylonglegs Re: Exclude specific... 11-12-2009, 04:35 PM
Runnit4 Re: Exclude specific... 11-12-2009, 04:41 PM
Runnit4 Re: Exclude specific... 11-12-2009, 04:42 PM
  1. #1
    Registered User
    Join Date
    11-11-2009
    Location
    Washington, DC
    MS-Off Ver
    Excel 2007
    Posts
    19

    Exclude specific parameters in a column while using SUMIFS

    Hey guys, I have a SUMIFS function written that reads where some of my budget is coming from. I track several different departments but am only responsible for some of the departments' budgets. So i need to exclude two of the departments when the SUMIFS is reading the other parameters from my list.

    From the example i attached, how would i go about writing the formula in I3 to skip the Cost if it comes from Dep 2 and Dep 4?

    Thanks for the help!
    Attached Files Attached Files
    Last edited by Runnit4; 11-12-2009 at 04:42 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