Totaling functions in Excel

[SueL]

Hi
I need to add totals with logical functions in an excel spreadsheet
I have a list of books, teachers, classes etc and I need a function that
will lookup the book name and total qty colums for that specific book.
I have tried using Dsum but the need to specify each book individually for
the criteria is slower than totaling manually.
Any suggestions?

 

[Mike H]

Hi,

A bit of sample data would have helped but what about this

=SUMIF(A1:A20,"Book_Name",B1:B20)

Mike

 

[SueL]

Thanks very much!
Embarrasing when something I've poured over for the last few hours is solved
in 5mins using a formula I couldn't get to work first time!!!