Hi all,
I'm new to this forum but I'll try to explain my problem as clearly as possible.
In the "Export value to the UK" column, I want to sum the values of exports to UK from "Other finance business services" and "Other business services n.i.e" for Austria.
The issue is SUMIFS returns a value of zero when there is two or more criteria for the same column.
The attached spreadsheet is a sample of the problem but ideally I'd like to replicate this with criteria of up to 10.
If anyone knows any formulas I can use to achieve this, that'd be great.
Thanks!
Bookmarks