Totaling functions in Excel

  • Thread starter Thread starter SueL
  • Start date Start date
S

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?
 
Hi,

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

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

Mike
 
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!!!
 
Back
Top