Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP PLEASE
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP PLEASE
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|