Hi I have the following formula which works fine for financials in AL...
=SUMIFS(AL:AL, $Q:$Q, "Y")
I have financials in AL and these will continually be added to.
I also have financials in AM and AN. Is it possible to add up all values in columns AL, AM and AN where Q = Y?
Or will I have to run the calculation 3 separate times and add up the result at the end?
Bookmarks