Is this what you mean?

=IF(B2="Monthly",OFFSET(F6,0,MONTH(TODAY()-1)),IF(B2="Quarterly",SUM(OFFSET(
F6,0,INT((MONTH(TODAY())-1)/3)*3,1,3)),IF(B2="Semi-Annually",SUM(OFFSET(F6,0
,INT((MONTH(TODAY())-1)/6)*6,1,6)),SUM(F6:Q6))))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Minitman" wrote in message
...
Greetings,

I have a formula the checks cell B2 for 1 of 4 conditions (Monthly,
Quarterly, Semi-Annually and Annually). The problem I am having is
trying to find the correct month or correct quarter or correct half
year to display. Here is the formula:



=IF(B2="Monthly",F6,IF(B2="Quarterly",SUM(F6:H6),I F(B2="Semi-Annually",SUM(F
6:K6),IF(B2="Annually",SUM(F6:Q6),0)))

The data I am trying to address is in row 6 on columns F through Q

This formula will give me the total for January (F6), 1st quarter
(SUM(F6:H6)), first half of the year (SUM(F6:K6) and the whole year
(SUM(F6:Q6)). The reference date is in row 4 to be matched with E3.

Any suggestions and help would be appreciated.

TIA

-Minitman