I have used the following formula to sum all items within a budget with the same code and period.
=SUMIFS('Actual 2013'!$F:$F,'Actual 2013'!$A:$A,"="&$A8,'Actual 2013'!$B:$B,"="&$B8)
Code criteria = A8
Code range = Actual 2013'!$A:$A
Dept criteria = B8
Dept range = Actual 2013'!$B:$B
The code criteria runs from A8 to A15 say.
I would like to now pick up all values within the Code range that don't match the codes from A8 - A15, but still matching the B8 department.
I have thought or using <> for each A8 - A18, individually, but where there are more codes I would run out of argurements so to speak. In addition, I have use OR before, but not sure how to introduce this to this formula.
thinking, but getting not very far, but hey I am trying.
=SUMIFS(OR('Actual 2013'!$F:$F,'Actual 2013'!$A:$A,"<>"&$A8,"<>"&$A9, etc....)'Actual 2013'!$B:$B,"="&$B8)
Is there a sumif, not in list option I could use?
Bookmarks