Good afternoon Forum,
I'm currently looking for a formula to capture a name and a fill colour and transfer it into a number.
To elaborate on what i'm asking for i've attached an example spreadsheet. What I require the IF statement (or other statement if required) to provide is to look at Columns C & D and report back the following;
IF[Column C matches the text "Person 1] then [Look at column D] If [Column D has a Red Fill] then [Add all red cells for this person and display in G6]
And
IF[Column C matches the text "Person 1] then [Look at column E] If [Column E has a Red Fill] then [Add all red cells for this person and display in G7]
I will then have a table (In this example Cells G6 & G7) which reports how many Red cells are highlighted for each individual person for both columns separately.
I know this sounds like a very complicated formula to make, however if anyone is up to the task i'd be endlessly grateful. If you need further information please ask as i'm sure I may not have explained as well as I could have
Many thanks,
Dr4ke