Hi All,

Like the title says, I would like a formula that adds up the values in Column A IF the Date in Column B is within a date range & value in Column C = TRUE.

The date range would be entered in 2 separate cells.

The cells in Column B are formatted as dd/mm/yyyy. Some of the cells in Column B are blank so I would assume the formula would ignore these.

I have tried the SUMIFS function but it didn't work for me. Maybe I need a VBA script or can it be done with formula?

Any help appreciated.