![]() |
How do I create a formula to add values from specific fields?
Example, from a list of several buyers who place orders on a regular basis, I
want to know how to write the formula in another table that adds the daily inputs and totals it for the specific month, for a particular buyer. So if I input the purchases of the day for 12 different buyers, if I want to check what a particular buyer has bought for the month, it will be in another table, but only the total to-date. |
Hi
I'd try using a pivot table for this. See: http://www.cpearson.com/excel/pivots.htm http://peltiertech.com/Excel/Pivots/pivotstart.htm http://www.contextures.com/xlPivot02.html http://www.ozgrid.com/Excel/excel-pivot-tables.htm http://www.techonthenet.com/excel/pivottbls/index.htm http://www.dicks-blog.com/archives/2...ble/trackback/ -- Regards Frank Kabel Frankfurt, Germany Greg wrote: Example, from a list of several buyers who place orders on a regular basis, I want to know how to write the formula in another table that adds the daily inputs and totals it for the specific month, for a particular buyer. So if I input the purchases of the day for 12 different buyers, if I want to check what a particular buyer has bought for the month, it will be in another table, but only the total to-date. |
All times are GMT +1. The time now is 01:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com