ExcelBanter - HELP PLEASE

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - HELP PLEASE (https://www.excelbanter.com/excel-worksheet-functions/231920-help-please.html)

START DATE: MARCH 26, 2006 (CELL K3)

JANUARY TO DECEMBER IN D8:O8
SUM D9:O9 + D10:O10 IN D11:O11
WITH REFERENCE TO START MONTH IN CELL K3 I NEED A FORMULA TO OVERRIDE THE
SUM FOR THE MONTH OF MARCH ONLY TO BE EQUAL TO 1(ONE) OR LESS THAN 1 (THE
REFERENCE HAVE TO BE MADE TO K3 BECAUSE I HAVE DIFFERENT START MONTHS)
--
KK

Hi Kay

Not sure that I understand your request.
Are you wanting to Sum the range of Jan to Dec, but only from the Month as
specified in cell K3?
If so, then
=SUM($O9:INDEX($D9:$O9,MONTH($K$3)))

--
Regards
Roger Govier

"Kay" wrote in message
...

START DATE: MARCH 26, 2006 (CELL K3)

JANUARY TO DECEMBER IN D8:O8
SUM D9:O9 + D10:O10 IN D11:O11
WITH REFERENCE TO START MONTH IN CELL K3 I NEED A FORMULA TO OVERRIDE THE
SUM FOR THE MONTH OF MARCH ONLY TO BE EQUAL TO 1(ONE) OR LESS THAN 1 (THE
REFERENCE HAVE TO BE MADE TO K3 BECAUSE I HAVE DIFFERENT START MONTHS)
--
KK