# Sumif discontinuos data on 1 row

1. ## Sumif discontinuos data on 1 row

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.

2. ## Re: Sumif discontinuos data on 1 row

Welcome to the forum!

Try the SUMIFS function. Without seeing your workbook, I can't be more specific.

3. ## Re: Sumif discontinuos data on 1 row

Hi,

=SUMIF(I13:XFD13,"Y",H13:XFC13)

Regards

4. ## Re: Sumif discontinuos data on 1 row

FORECAST.JPG

Attached is a snapshot of the spreadsheet i'm trying to 'fix' - 'D' is where i want the total of 'H, K, N...' based on 'I, L, O...' being "Y".

NB: i believe XOR LX 's answer solved this. Thank you

5. ## Re: Sumif discontinuos data on 1 row

There are currently 1 users browsing this thread. (0 members and 1 guests)