Calculating Percentages

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

Code:

---

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)

---

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

Code:

---

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

---