hi

Is it possible to combine the IF, OR and MONTH formula?

I need to get the total result of multiple cells where the month in todays date matches that in the referred cells

This is what I want to say and which is logical to me but I can't transfer it to excel :

=IF the MONTH in todays date is the same as the month in Cell1 then add up these cells OR IF the MONTH in todays date is the same as the month in Cell2 then add up different cells..etc etc

I've attached a sheet to explain this better with a text box and comments

Forum Help If month.xlsx

Thanks for your help as usual - 100% success rate to date! Always so impressed!

Paul