Dec 02 2020 11:24 AM
A B
1 general 10.34 The function would give 30.43 for the sum of "books"
2 general 5.37 There are over 1,000 rows in column A and B
3 books 9.34
4 general 15.25
5 general 8.76
6 books 7.40
7 books 13.69
.
.
.
Dec 02 2020 11:37 AM
=SUMIF(A:A,"books"",B:B)