Hi all I have 3 columns
Column A - Dates in chronological order
Column B - Various Colours
Column c - A Cost
example data
01/11/2020 Red $23
04/12/2020 Green $4
31/12/2020 Blue $44
01/01/2021 Red $5
03/01/2021 White $8
I would like to specify a date range in the formula of a start and finish date choose a colour and the result of the formula is the sum
example
start date 01/11/2020 end date 01/01/2021 colour Red result = $28
what's the best way this is achieved ?
Column A - Dates in chronological order
Column B - Various Colours
Column c - A Cost
example data
01/11/2020 Red $23
04/12/2020 Green $4
31/12/2020 Blue $44
01/01/2021 Red $5
03/01/2021 White $8
I would like to specify a date range in the formula of a start and finish date choose a colour and the result of the formula is the sum
example
start date 01/11/2020 end date 01/01/2021 colour Red result = $28
what's the best way this is achieved ?