Results 1 to 7 of 7

Nested SUMIF function to create a transcript

Threaded View

wildenbeast Nested SUMIF function to... 09-26-2016, 05:53 PM
Ash_Maverick Re: Nested SUMIF function to... 09-27-2016, 07:26 AM
wildenbeast Re: Nested SUMIF function to... 09-27-2016, 11:31 AM
JohnTopley Re: Nested SUMIF function to... 09-27-2016, 02:53 PM
wildenbeast Re: Nested SUMIF function to... 09-28-2016, 01:19 PM
JohnTopley Re: Nested SUMIF function to... 09-28-2016, 02:27 PM
wildenbeast Re: Nested SUMIF function to... 09-28-2016, 05:50 PM
  1. #1
    Registered User
    Join Date
    09-26-2016
    Location
    Santa Rosa, CA
    MS-Off Ver
    MS 2013
    Posts
    12

    Nested SUMIF function to create a transcript

    I am creating a transcript for a specialized school where students are referred from different district and have different requirements. I am trying to sum the credits of sub courses under a criteria. For English courses, there are 4 sub courses that should be counted under "English" and students can take these at different grades. Here is what I have tried and seems to not be successful:

    =SUM(IF((G11:H20={"English","English/Language Arts","Composition","American Literature"})+ (G23:H34={"English","English/Language Arts","Composition","American Literature"})+(K11:L20={"English","English/Language Arts","Composition","American Literature"})+(K23:L33={"English","English/Language Arts","Composition","American Literature"})+(G36:H44={"English","English/Language Arts","Composition","American Literature"}), J11:J20+J23:J33,N11:N20,N23:N33,J36:J44))

    I hope what I am trying to do makes sense after opening the worksheet.

    Thanks.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] how to create nested if function for military time
    By km117 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-19-2022, 04:31 AM
  2. [SOLVED] Nested Sumif's or how to sum data based on nested criteria
    By dlietz in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-07-2014, 11:36 AM
  3. How to create a sumif function with two criteria
    By Martin9 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-04-2012, 08:56 AM
  4. Will a Nested IF/SUMIF function instead of VBA?
    By Ronny Hamida in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-03-2006, 06:35 PM
  5. A college transcript template in Excel
    By avr320 in forum Excel General
    Replies: 0
    Last Post: 05-26-2005, 05:15 PM
  6. How to I use nested quotation marks for 'SUMIF' function in Excel.
    By Glenn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-04-2005, 08:06 PM
  7. [SOLVED] Nested SUMIF function
    By A P in forum Excel General
    Replies: 1
    Last Post: 03-02-2005, 05:06 AM

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