LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
pdberger
 
Posts: n/a
Default use sumif with array

I'm trying to model patient flow delays through a receptionist and a nurse to
see a doctor. I've got a two dimentional array, with the distribution of
delays created by a receptionist across the top, and those created by nursing
preparation down the side. In each cell, I have the percentage of patients
experiencing that combination of delays:

Receptionist Causes
2min 3min 4min 5min 6min
N 4min 2% 3% 6%
u 6min 8% 11%
r 8min 5%
s
etc.

I want to create a histogram from this table showing the total percentage of
patients experiencing each level of delay. Then, I can go back and design
process changes or staffing changes to reduce those delays in a predictable
way. Also, I can use the output as input for queueing models at the next
step (say, the doc, the lab, x-ray, an expensive piece of equipment, etc.)

Can I use a SUMIF function to add the respective table headers (top & side)
into a single sum and use that sum for the if condition? Or do I have to
write a bunch of VBA language?

Thanks in advance.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to use SUMIF to return sums between two values located in cells ScottBerger Excel Worksheet Functions 2 April 23rd 23 09:05 PM
Modify SumIF... Array Formula carl Excel Worksheet Functions 2 May 17th 05 07:52 PM
Modify SumIF... Array Formula Peo Sjoblom Excel Worksheet Functions 0 May 17th 05 06:15 PM
sumif and array formulas Simon Murphy Excel Worksheet Functions 4 January 25th 05 05:22 PM
SUM(IF( Array to avoid #NUM! values Elijah Excel Worksheet Functions 7 November 21st 04 02:17 PM


All times are GMT +1. The time now is 08:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"