Hi All,
Looking for a little assistance with the below, it has me a little baffled.
I'm looking to have a 'sumifs' statement that can use a multiple criteria statement (i.e. {1,2,3,4}) and have this directly referenced in a cell.
Here is a simplified version of the working formula:-
=SUMIFS(B:B,A:A,{1,2,3,4})
Where the criteria {1,2,3,4} in the formula is replaced with a cell reference with those contents in. So this may look like:
=SUMIFS(B:B,A:A,A1) Cell 'A1' Contents = {1,2,3,4}
I have had multiple attempts to get this to work but have failed and would very much appreciate it if one of you chaps (or ladies) may be able to assist?
Thanks in advance.
Stuart
Bookmarks