I need some help with a formula.

In my attachment, I'm really referring to the cells that appear at f146 - that would be the first one.

So, I want to sum up cells that meet a few criteria - for the "Current," line, the values to sum would come from other "Current" rows.

For the "Weekday," portion, the values to add would come from the values listed as weekday in column a.

The difficult part is - the length of the month changes all year and I will never know which month will be thrown at me.

To verbalize that formula, I need to sum up values from column F that are in the same month we are trying to total, are the current figures and are weekdays. I need the formula to be flexible enough and actually search for the appropriate values to add from the range F22:F700 (so I can use the same formula regardless of the changes the calendar causes).

Any help would be GRREATLY appreciated.upload.xlsm