Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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. |
#2
![]() |
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula for Searching & matching two values in excel | Excel Discussion (Misc queries) | |||
Formula to list unique values | Excel Worksheet Functions | |||
Need formula to check values of data in several cells as criteria | Excel Worksheet Functions | |||
manipulating formula values | Excel Worksheet Functions | |||
How do I create a formula in Excel that will countif or sumif bef. | Excel Worksheet Functions |