PC Review


Reply
Thread Tools Rate Thread

How to do average turn around time with criteria

 
 
BrettS
Guest
Posts: n/a
 
      17th Jun 2008
I currently have a spreadsheet tracking the performance of a purchasing
group. There are 3 columns of interest to me in this formula. Column D is
the purchasing group, some are names, some are acronyms, but the groups I'm
concerned with are all named "Purchasing____" followed by a number, so I have
been using the "Purchas*" value to capture all of those. Column J is the
date a purchasing group has received an order, and Column P is the date the
purchasing group sends out its purchase order. This data is being captured
in a separate workbook, and there is also a date criteria. So I have set up
hidden cells in the workbook capturing the data, with the corresponding
column head and values I'm looking matching up with column D, J, and P. J
and P have two hidden cells each, to represent the upper and lower bounds of
the date ranges I'm looking for.

I'm looking to come up with a function that will go to every entry in column
D that is a "Purchasing____" (hence the "Purchas*"), find the NETWORKDAYS
between J and P, and then average them by month (hence the date constraints).
Any help would be much appreciated, thanks.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
average using two criteria DJ Microsoft Excel Worksheet Functions 2 9th Jul 2009 09:24 AM
Average with Criteria Sassy Microsoft Excel Worksheet Functions 10 7th Jun 2009 02:59 AM
Average top third with criteria deeds Microsoft Excel Worksheet Functions 2 11th Mar 2009 10:09 PM
average with 2 criteria hockeyb9 Microsoft Excel Worksheet Functions 10 22nd Aug 2008 08:46 PM
Capturing average turn around time with constraints BrettS Microsoft Excel Worksheet Functions 0 17th Jun 2008 03:12 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:51 AM.