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!
Last edited by Runnit4; 11-12-2009 at 04:42 PM.
Here's one way...
=SUMIFS(F3:F12,D3:D12,"Shipping",G3:G12,"Jan",E3:E12,"<>Dep 2",E3:E12,"<>Dep 4")
Great, i guess i just didnt know how to exclude certain elements. Thanks!
As you helped me yesterday, it tells me i can't Up your reputation, but thanks for the help anyway!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks