SUMIF Children, Referencing Another Sheet
I am creating a summary sheet and would like to include a sum of course developments by college. I know how to do a SUMIF in general, but can I use the CHILDREN function to sum (or count the number of instances) of courses/payments based on the value in the College column?
Source Sheet
The parent is called 201910, and all of the courses are listed as children, under this parent. College values can be PS, KC, ED, or UG (Col 6).
Summary Sheet
- I want to COUNT the number of courses on the development list for each college (so count the course if the course is associated with a particular college (Col 6). what is the total number of courses for PS, KC, ED, and UG?
- I want to SUM the amount of payments (Col 15) to SMEs working on courses associated with a particular college (Col 6).
I assume the structure of the COUNTIF or SUMIF is the same, I am just stuck on how to use the CHILDREN() function as I reference a different sheet.
Thanks!!!
Comments
-
The CHILDREN function unfortunately cannot be used in cross sheet references. If you would like... Go ahead and submit an enhancement request.
-
Paul Newcome - Hello, I have the same conundrum. I want to sum children rows only from another sheet. Do you know if this enhancement was ever activated?
Thank you,
Mary Peterson
Categories
- All Categories
- 14 Welcome to the Community
- 10.9K Get Help
- 65 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.6K Ideas & Feature Requests
- 56 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives