SUMIFS Across Two Sheets with Multiple Criterion
Hi All,
I am looking for a the next step of this formula, I now want to include a department filter on this SUM Formula instead of all departments? is that possible
=SUMIF({Timesheet Range 1}, =[Export Title]@row, {Timesheet Range 4}).
Timesheet Range 1= Phase Name - Sheet 1
Export Title= Phase Name - Sheet 2
Timesheet Range 4 = Total Cost - Sheet 1
NEXT Step Add This into Equation
Timesheet Range 2 = Department Name- Sheet 1
Department= "Name" - Sheet 2
Answers
-
Hey @Brendan Ginns,
Instead of using the SUMIF Function, which can only accept a single criteria, use the SUMIFS Function which works with multiple criteria. You may add the Department Range and Name criteria alongside your pre-existing criteria. I've created the example below to demonstrate this:
Formula (highlighted in yellow): =SUMIFS(Cost:Cost, Item:Item, "Apple", Type:Type, "Fruit")
I hope this helps!
Jaykel
-
Hey Jaykel,
this is a great example. Do you know if this works on cross sheet formulas? Let me know
-
Yes! To change this to be a cross-sheet formula you just need to adjust the column ranges.
Instead of typing Cost:Cost, you would use a cross-sheet reference, {Cost Column}
So in your instance, something like this:
=SUMIFS({Timesheet Range 4}, {Timesheet Range 1}, [Export Title]@row, {Timesheet Range 2}, Name@row)
See: Cross-sheet formulas
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!