SUMIFS formula

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
Comments
-
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)
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives