| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate Monthly Inventory Usage
I'm trying to calculate monthly inventory usage from data retrieved from
daily usage reports. The formula below works, but not sure how to ignore rows with receiving data. Column "C" includes notes and I would like to ignore in my calculation all rows with the note of "Received against PO". How can this be accomplished? The formula I'm currently using is... =SUMIF($H$2:$H$100,"1/2009",$D$2:$D$100) Column "H" has the month/year and column "D" includes both usage and receipts. Thanks in advance! Brian |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to sort usage of rented rooms on monthly basis? | Charts and Charting in Excel | |||
| Finding Monthly Usage | Excel Worksheet Functions | |||
| How can I take my monthly bar and kitchen inventory? | Excel Discussion (Misc queries) | |||
| Making list of items to truck monthly usage | Excel Discussion (Misc queries) | |||
| How do I create a spreadsheet to track monthly inventory | New Users to Excel | |||
Threaded Mode
