I have a budget sheet that I want to pull total monthly expenses from another sheet. The below formula is calculating the total [Health & Safety] spend, but I want it to only calculate expenses for June. I have another column which picks up the month from the date column. I am wondering if it is a SUMIFS formula and I need to add AND, but can't quite figure it out. Appreciate your help. =SUMIF({Archived Expense Reports Range 1}, "Health & Safety", {Archived Expense Reports Range 2})

We can actually reference the Date column directly instead of needing the helper column with the month pulled out. =SUMIFS({Archived Expense Reports Range 2}, {Archived Expense Reports Range 1}, "Health & Safety", {Date Column}, IFERROR(MONTH(@cell), 0) = 6) The above will take into account all rows where the date is in the month of June. This does not matter which year it is in though. If you wanted to specify the year as well (June of 2021 for example), it would look like this... =SUMIFS({Archived Expense Reports Range 2}, {Archived Expense Reports Range 1}, "Health & Safety", {Date Column}, AND(IFERROR(MONTH(@cell), 0) = 6, IFERROR(YEAR(@cell), 0) = 2021))

SUMIFS Formula Reference Another Sheet

Answers

Paul Newcome ✭✭✭✭✭✭

04/01/24

@simonvodo Give this a try:
=SUMIFS({Leave Requests Days Out}, {Vacation Day Requests Employee Name}, [Employee Name]@row, {Leave Requests Approval}, "Approved", {Vacation End Date}, @cell>= DATE(YEAR([Anniversary Date]@row) - 1, MONTH([Anniversary Date]@row), DAY([Anniversary Date]@row)))

Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Trending in Formulas and Functions

MAX COLLECT Formula Question
Hi, I'm trying to create a formula that displays monthly electric meter readings. I have 2 sheets, one which I have the weekly meter readings (Meter Readings Submission) and the other is the metrics sheet which should display the monthly reading(Pitchside Meter Readings Metrics). My current formula is the below, but it…
Index Match for Contact List
I'm using an IFERROR formula with INDEX MATCH to pull names from two separate sheets, both of which use a contact list column type. However, for some entries, I get a contact list icon (with the email attached), while for others, I only see the individual’s name as plain text. I can't figure out why there's an…
Need to highlight if two numbers in two different columns match
I have a number of days column called "Adjusted Duration" (it is calculated from two other columns) and then I have a helper column called "Days" that is a number that is converted from the System Duration column into a number using this formula (=Duration@row). I need to compare these two numbers (Adjusted and Days) and…

SUMIFS Formula Reference Another Sheet

Answers

Help Article Resources

Categories