Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Summing a column based on 3 other columns

0

I am trying to get the sum of all occurences in a column based on data in 3 other columns. I want the total number of absences (column E), based on the current school (B) and if they are FRL (C), The fly in the ointment is the 4th factor....Other ID (A), which shows individual student records.  Some kids have only one record, others have multiple records from previously enrolled schools (column E).  I'd like my formula to look at the ID, the current school and the FRL and give me a total sum of absences.

So, for example, I want to see the total number of absences for FRL kids currently at Badger Mountain Elementary, regardless of where they had those absences.

My data is attached.

Can this even be done with a formula? I'm not a complete beginner, but am very, very far from an expert.  Using Excel 2013.

Thanks in advance. 

excel
MS Office Version: Excel 2016
posted by: vonderto (rep: 4) on Thu Dec 22, 2016 at 1:47 pm
Answer
Discuss

Answers

0
Selected Answer

You can use a SUMIFS() function like this:

=SUMIFS(D:D,C:C,"Yes",A:A,A2)

Put it in row 2 column F and copy it down.

This will give you the count of the absences for each "Other Id".

You will need to have another setup that lists each student with all of their ID numbers in order to correctly combine them for each student.

posted by: don (rep: 1989) on Sat Dec 24, 2016 at 3:53 am
Discuss

Discussion

Thanks!  That appears to do the trick.  The Other ID is alwasy the same for each student, regardless of what school they were at, so I think this gives me what I need. Much obliged!
vonderto (rep: 4) Jan 9, '17 at 5:35 pm
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login