View Full Version : Sleeper: Calculating Percentages

11-15-2009, 11:31 PM
Hi Everyone!

I am trying to calculate percentages using array formulas. I have a dashboard that will show the allotment of cases for each day. Part of the dashboard is to show the % cases by day. Can someone tell me what I am doing wrong with my formula

For cell b4=(SUM(IF((TypeofCase="Emergency")*(DateofActivity=($A10-1)),1,0)+SUM(IF((TypeofCase="Emergency")*(DateofActivity=$A10),1,0))))/SUM(IF((COUNTA(TypeofCase)),1,0))

For cell c4=(SUM(IF((TypeofCase="Non-Emergency")*(DateofActivity=($A10-1)),1,0)+SUM(IF((TypeofCase="Non-Emergency")*(DateofActivity=$A10),1,0))))/SUM(IF((COUNTA(TypeofCase)),1,0)

Bob Phillips
11-16-2009, 01:47 AM
What are you trying to do? The syntax of using For in that code looks totally wrong. If you want to set an array formula, then use

Range("B4").FormulaArray = "formula"