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(F6: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