# SUMIFS with multiple SUM and Criteria Ranges

1. ## SUMIFS with multiple SUM and Criteria Ranges

Hi All,

I've been looking for days to find a solution to this problem I and to be honest I am shocked no one else has posted it so I am either blind or this is so obvious that no one asks...

Ill attach an excel file to demonstrate the data I have, What I need to do is based on Language, Grade and Week to give a result.

So lets say in Sheet 2 I want to display the result for the following data: Language: English, Grade: A, Week:5

Expected result is: 7

Book1.xlsx

2. ## Re: SUMIFS with multiple SUM and Criteria Ranges

hi Xerxies, welcome to the forum. try:
=SUMPRODUCT((A5:A16="English")*(C5:C16="A")*(E1:P1=5),E5:P16)

3. ## Re: SUMIFS with multiple SUM and Criteria Ranges

=SUMPRODUCT((A5:A16=A5)*(C5:C16=C5)*(E1:P1=E1)*(E5:P16))
A5, C5, E1 you can change to other cells

4. ## Re: SUMIFS with multiple SUM and Criteria Ranges

Many thanks guys, this formula works like a charm!

5. ## Re: SUMIFS with multiple SUM and Criteria Ranges

Or (of course) with an pivot table.

See the attached file.

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