HELP PLEASE

[Kay]

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)

 

[Roger Govier]

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)))