Totaling functions in Excel

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?
 
M

Mike H

Hi,

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

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

Mike
 
S

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Having trouble totaling columns in excel 2003, always worked b4 1
calculation time problem 3
any ideas if this can be done 2
Excel formula question 1
How do I add a second criteria to the SUMIF or DSUM function? 2
Functions in Excel 1
Can't get any of my functions to run in Excel 2007 2
Referencing text from another cell for criteria in functions 1

Top