So currently in this example, I am using the formula (=SUMIF($G$5:$G$13,$H18,K$5:K$13) to find the total per group by month….but I had to add another column to find the amount by multiplying the amount by and percentage….but was hoping there is a formula where I can just perform SUMIF and nest a sumproduct within it (basically I want to remove column K)…so than I can drag the formula for the other months….is there such a way to do this…any assistance will be utmost appreciated.
Bookmarks