|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 13th, 2008, 11:37 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? 
|
|
#2
October 13th, 2008, 11:44 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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?
|
|
#3
October 13th, 2008, 11:50 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
