Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am working on a spreadsheet that tracks when an item is requested, the type
of request it is, when it returns and the age of the outstanding items. I have used formulas to automatically enter the type of item being requested and the age of the outstanding items. What I want to do is count the number of outstanding item#1s that are over 40 days old. The type of item is in Col. I and the age of o/s items is Col. V. I've tried to use the sumproduct formula but I'm not getting the right totals. Help is greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find Count of Items with certain criteria | Excel Discussion (Misc queries) | |||
Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
Counting "rows", i.e. simultaneous criteria for multiple cells | Excel Worksheet Functions | |||
calculate percent from multiple criteria | Excel Worksheet Functions | |||
Count rows based on multiple criteria | Excel Worksheet Functions |