Results 1 to 3 of 3

Adding two array formulas

Threaded View

Jubinell Adding two array formulas 05-22-2013, 06:08 PM
djapigo Re: Adding two array formulas 05-22-2013, 06:37 PM
Jubinell Re: Adding two array formulas 05-23-2013, 07:13 AM
  1. #1
    Registered User
    Join Date
    09-19-2009
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    4

    Adding two array formulas

    Hi,

    I have a table that shows scores of questions in a test. Each question belongs to a subject, say "Physics", "Maths", etc. The scores can be 0 or 1.

    Now I want to calculate the percentage correct in a given subject in one cell.
    Normally, I would have made two named ranges for the subject and score cells, then used the array formula: sum((subject="Math")*(score)). However this only gives me the absolute score. Can I, in the same cell, calculate the proportion? I envision doing this by adding to the first array formula the following second array formula:
    sum(subject="Math")

    I'm using Excel 2013. Thanks!
    Last edited by Jubinell; 05-22-2013 at 06:09 PM. Reason: More details

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1