SUMIF
Is it possible for the condition of a SUMIF to refer to another table on the same sheet? It doesn't seem to work!
I have a table with 80 or so rows of numerical data. When I write a few rows on the same table using SUMIF to total up amounts in a column that meet certain criteria in another column then it works fine. However, when I write the same formula in another table referring to my data table, it doesn't seem to work. Not a syntax error but just seems to ignore the 'condition' part of the statement.
Any ideas would be much appreciated, thank you.
Mac mini (M1, 2020)