Calculate the total number of People on a training course at a certain time in the day.
Hi All
I am trying to build a formula that can calculate the total number of maximum people that can attend training course at each time of the day, the course codes are text so it would need a reference for the numerical value.
I am using drag & drop text values that need to be converted and added up in a summary field, I have build an example sheet to hopefully explain it better.
Any help is much appreciated.
Paul
In C3 then copied across.
=SUM(MMULT(0+($P$15:$P$20=TRANSPOSE(IF($B$13:$B$33=$B3,C$13:C$33,"Z"))),0+(ROW($B$13:$B$33)>0))*$Q$15:$Q$20)
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Thank you kvsrinivasamurthy it worked perfect
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks