| Home |
| Search |
| Today's Posts |
|
#1
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
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
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Identifying and totaling up duplicate cells in Excel | Excel Worksheet Functions | |||
| Why did my Excel Checkbook stopped totaling after 30 entries??? | Excel Discussion (Misc queries) | |||
| Excel is totaling wrong | Excel Worksheet Functions | |||
| excel totaling wrong | Excel Discussion (Misc queries) | |||
| Totaling columns of text in Excel | Excel Worksheet Functions | |||
Linear Mode
