Hello all,
I'm hoping this is a simple one for one of you Excel wizards!!
I would like to add the value of a cell in a given column when 2 different criteria are met in adjacent cells in adjacent columns.
For example, if a cell in column A reads a £ value, and a cell in column B reads 'won', and a cell in column C reads 'JANUARY', I'd like D1 to show the total £'s of all cells in column A that meet this criteria.
I need to use the same formula for each month of the year.
Hope this is clear and an easy one for you to answer.
Thank you in advance!!!!
I'm hoping this is a simple one for one of you Excel wizards!!
I would like to add the value of a cell in a given column when 2 different criteria are met in adjacent cells in adjacent columns.
For example, if a cell in column A reads a £ value, and a cell in column B reads 'won', and a cell in column C reads 'JANUARY', I'd like D1 to show the total £'s of all cells in column A that meet this criteria.
I need to use the same formula for each month of the year.
Hope this is clear and an easy one for you to answer.
Thank you in advance!!!!