SUMIFS formula

Crystal Panning

Hi, 

I have a set of a set of data that I am trying to do a SUMIF formula on and am having difficulty finding the correct formula, Essentially I have 3 columns. 

Project Quarter

Pyramid

Sample Size

I am trying to sumif the Sample Size column range if the criterian is met for a specific project quarter and pryamid. 

 

For example, sumif the counts in the sample size column if the quarter is Q1 and the Pyramid is Pyramid A. 

This is the formula I have, but is still not working. Any ideas on what I need to alter? 

=SUMIFS([Sample Size (# only)]:[Sample Size (# only)], [Project Quarter]149, [Project Quarter]:[Project Quarter], Pyramid131, Pyramid:Pyramid)

 

Thank you,

Crystal 

 

Paul Newcome

You just have your range/criteria sets backwards.

.

You have...

 

=SUMIFS(range to sum, criteria 1, range 1, criteria 2, range 2)

.

It should be...

 

=SUMIFS(range to sum, range 1, criteria 1, range 2, criteria 2)