Hi,
I am trying to write a "SUMIFS" formula with multiple criteria in the criteria range (one column).
For example I am trying to group specific coding locations & total the expenditure. It is doing my head in!!
In the attached image I want to group the highlighted codes into a group with the total amount, I can not shift or sort the data I have to work with its current layout.
Any suggestions?
Thanks in advance
DATA.jpg
Bookmarks