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.