| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
need help with formula
I need some help with a formula:
I have a list of weights and the dates they were received. i need to find the total tonnage for each month....and the average for each month. i.e. sum all the weights that were received in jan, then feb, etc..... I'm not sure where to start, but something like this?... =sum B1:B10 if A1:A10 is "jan" or "01" =sum B1:B10 if A1:A10 is "feb" or "02" ....etc.. Doesn that make any sense? Jeremy -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200508/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
| Simplify formula | Excel Worksheet Functions | |||
| put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
| how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Threaded Mode
