I have used and tried each of these formulas separately and they work beautifully.
=SUMIFS([Total Savings]@row, Lane@row, "IL5"
=SUMIFS([Total Savings]@row * 90 / 100, Lane@row, "IL4"
=SUMIFS([Total Savings]@row * 50 / 100, Lane@row, "IL3"
=SUMIFS([Total Savings]@row * 10 / 100, Lane@row, "IL2"
=SUMIFS([Total Savings]@row * 1 / 100, Lane@row, "IL1"
= SUMIFS([Total Savings]@row * 0, Lane@row, "IL0"
However, what I need to do, is combine them into one. Below is what I tried to do, but I keep getting INCORRECT ARGUMENT. Can someone please help me figure out what I'm doing wrong?
=SUMIFS([Total Savings]@row, Lane@row, "IL5",SUMIFS([Total Savings]@row * 90 / 100, Lane@row, "IL4", SUMIFS([Total Savings]@row * 50 / 100, Lane@row, "IL3", SUMIFS([Total Savings]@row * 10 / 100, Lane@row, "IL2", SUMIFS([Total Savings]@row * 1 / 100, Lane@row, "IL1", SUMIFS([Total Savings]@row * 0, Lane@row, "IL0"))))))
Thank You!