How to write a formula for excel?

Question

excel

There are 2 columns, A and B. There are only 2 values ​​in column A, black and white. Numbers in column B.
How to write formulas to separately calculate the sum of the values ​​of column B for blacks and separately for whites? About 3000 lines.

Answer 1

You need to use the SUMIF formula .

Answer 2

add a third column, and transfer one of the colors there (black for example), calculate the sum of the column.

Answer 3

Buddy, this is only with the help of macros, because. in Excel formulas, I did not find the ability to specify the color. There is a site wordexpert.ru there on the forum ask the guys this is their topic. Good luck!