Sum of numbers. in Col. B with "books" as label in Col. A

Copper Contributor

     A                 B

general     10.34                          The function would give 30.43 for the sum of "books"

general       5.37                             There are over 1,000 rows in column A and B

books         9.34

general     15.25

general      8.76

books        7.40

books     13.69

.

.

.

 

 

1 Reply

@denamark1 

=SUMIF(A:A,"books"",B:B)