I have a spreadhseet that forecasts and tracks project invoicing. I am trying to calculate the total sum of claims in 'D13' for respective months 'H13,K13,N13....' ONLY if they have been sent (Y) 'I13,L13,O13....'
I have made a simple SUMIF(I13,"Y",H13)+SUMIF(L13,"Y",K13)+.... But i want to know if there is a better way around this so i can easily update the ranges when i create new columns in months/years to come.
Thanks.
Bookmarks