Consulting

Results 1 to 2 of 2

Thread: Sleeper: Calculating Percentages

  1. #1

    Sleeper: 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

    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)

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    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"
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •