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.
Bookmarks