Totaling functions in Excel
 

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?

Totaling functions in Excel
 

Hi,

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

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

Mike

"SueL" wrote:

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?

Totaling functions in Excel
 

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!!!

"Mike H" wrote:

Hi,

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

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

Mike

"SueL" wrote:

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?