Hi,
I am trying to set up the following SUMIFS formula referencing a table, but it always results in a #VALUE! error.
Formula.jpg
This is the table I am referencing:
Table.jpg
I would appreciate any assistance in getting this formula to work. If possible, I would like it to cater for additional columns - using the example above, when I add 'MAY-22' to the right of the table, I would like that column to automatically be included in the SUMIFS formula.
Please let me know if you require further information.
Thanks in advance!
Bookmarks