Formula for SUMIFS horizontal DOESNT WORK

Hi All

I have worksheet with a list of products on the side and I am looking for a formula that will be give me the YTD number between a set of period but in a horizontal form.

I have attached an sample worksheet of what I am trying to do.

In yellow are the periods I want return. e.g P1-P5 = 0.756 and between P6-P8 =0.451 for Apples.

I have tried the following formula in green in cell M7: =SUMIFS('BRAND PHASING'!K12:V12,'BRAND PHASING'!K11:V11,">="&O6,'BRAND PHASING'!K11:V11,"<="&P6)

between periods P1 and P5 it should return 0.7561 but it returns 1.15. which is wrong.

Hopefully someone can help me!

Thanks

Because operator doesn't work on text. If you convert your periods to just numbers, it should work.

You still can do it with your original layout

Formula:

Please Login or Register  to view this content.

Or just this

Formula:

Please Login or Register  to view this content.