Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating column amounts
I have 2 columns, 1 contains an item code and the other the qty booked out
against that code number. The items are booked out during the day and entered as they occur. I would like to enter a formula that calulates how many times during a month that item code number occurs and what the total qty used in that month. I am using the COUNTIF function but that will only give me the amount of times a particular code number has been used. Can anybody suggest a suitable formula. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I change column totals from number signs to amounts? | Excel Discussion (Misc queries) | |||
total column amounts from non-contiguous rows | Excel Discussion (Misc queries) | |||
column of dollar amounts don | New Users to Excel | |||
How can I sum only amounts that are in BOLD format within a column | New Users to Excel | |||
Excel formula needed to amounts into one column pulling from 2 col | Excel Worksheet Functions |