View Single Post
  #1   Report Post  
mbparks
 
Posts: n/a
Default Count of items using multiple criteria

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.