scoobyblue
Active Member
- Joined
- Jun 30, 2004
- Messages
- 380
Having read through many of the posts regarding this I believe I am asking for something a little different.
I know how to use SUMPRODUCT to count occurences in one column that match certain conditions in another column, if that makes sense, and how to use COUNTIFCOLOR!
I want to in effect combine COUNTIFCOLOR and SUMPRODUCT so where there is the colour (45) in a cell (input manually), I can total what is in the adjacent cell in the next column.
Let me explain what I am doing; for example - cells in Column A will either be BLANK or Orange (45), which denotes an Appearance. Cells in Column B will show either "WON","Drew" or "LOST". The idea being that I can TOTAL the Appearances by WON, Drew or LOST (where cells in Column A are Blank, nothing will be totalled).
Many Thanks,
Scoobyblue
I know how to use SUMPRODUCT to count occurences in one column that match certain conditions in another column, if that makes sense, and how to use COUNTIFCOLOR!
I want to in effect combine COUNTIFCOLOR and SUMPRODUCT so where there is the colour (45) in a cell (input manually), I can total what is in the adjacent cell in the next column.
Let me explain what I am doing; for example - cells in Column A will either be BLANK or Orange (45), which denotes an Appearance. Cells in Column B will show either "WON","Drew" or "LOST". The idea being that I can TOTAL the Appearances by WON, Drew or LOST (where cells in Column A are Blank, nothing will be totalled).
Many Thanks,
Scoobyblue