-
SUMIFS Formula, Criterion change based on row
I am working on an attendance tracker that counts the points "Occurrence" someone "Employee Name" gets for missing work in a rolling 12 month span "Rolling 12 Months?". I am attempting to use a SUMIFS formula to create a running total "YTD" of the points someone has accumilated, using the criteria of their name, in the…
-
Unparsable formula; Sheet summary SUMIF formula
Can anyone help why this formula is coming up as unparseable? I'm creating a sheet summary, where it totals the Estimated GP (Est. GP) column if the Status column has the "Quoted" drop-down option is selected. Formula i've used: =SUMIF(Status:Status,"Quoted",Est. GP:Est. GP) Thanks a lot!
-
SUMIFS with date and category referencing another sheet
Hi - I have a cashflow chart that I want to pull expenses into by category and month. The expenses are located on another sheet with a dropdown list that is the same on the cashflow chart. I have tried this formula but it is not returning the results - just $0.00 =SUMIFS({Expenses Amount}, {Expenses Category},…
-
SUMIFS Unparseable Error
Hi, I'm attempting to use SUMIFS to sum data (Royalty Rate) from another sheet if the Project Number in the other sheet (Project Num) matches Project Number in the current sheet, and if Based on from the other sheet is "SRP". Current formula that isn't working is below. =SUMIFS({Royalty Rate}, {Project Num},[Project…
-
Using SUMIFS with Cross Sheet References and CONTAINS
There seems to be lots of information on how to use SUMIFS with a CONTAINS criteria, referring to another sheet. Here is my formula on Sheet 1: =SUMIFS({Total Cost - Final Event Space Cost}, {Requested Event Date}, {Requested Event Date} > TODAY(), {Requested Event Date}, {Requested Event Date} >= TODAY(-365)) Total Cost -…
-
Trouble gathering a SUM from another sheet.
I've been running into an issue where I have a sheet that gathers all information from a form. Im trying to gather a sum of a total of a column, but only reference the values of specific rows that from column. Example: I have Column to indicate "fixture color" that will be a specified by the form. I want to sum another…
-
IFSUMS using word and numbers
Hello, I am building a matrix sheet to pull data from a source sheet and trying to use an IFSUMS formula, but have received various outcomes #UNPAREBLE =SUMIFS(({Evt Support Level},[Event Support Levels]@row , {Event Month}, May1)+sumif({Event Year}, 2025)) #INCORRECT ARGUMENT SET - =SUMIFS({Evt Support Level}, [Event…
-
SUMIFS cross-reference date ranges
This is my formula. It's "working" in the sense that it doesn't return an error but it returns a 0 value for each instance when I know some of the values should be non-zero. Any advice is appreciated. =SUMIFS({Consortium HC}, {Consortium Start Date Range}, >=[Week Start]@row , {Consortium End Date Range}, <=[Week End]@row)
-
SUMIFS Formula with Dates
Having some issues with a formula to gather project budget metric data. I want to sum the values between a date range for each project. I get the invalid operation error on the formula: =SUMIFS({Cost}, [Primary Column]@row = {PrjNm}, {Date} < DATE(2024, 12, 31))
-
My IF Formula only works in certain cells in my grid
I have a formula in my sheet that sums the hours by project, phase and category. Ie for a row with task 1 I get the sum of (1) total hours logged on timesheets, (2) Design Engineer Hours (2) Senior Design Engineer Hours, and (3) Principal Hours. The formulas are as follows: Total Hours: =IF([Budget:]@row > 0, SUMIFS({TS…
-
How to calculate sumifs across multiple columns
Hello community! I am trying to build a summary worksheet to get an overview of all the meeting categories but my raw data has multiple data columns and the formula I am using comes up as an error Summary sheet Raw data I need to get a total sum from both "no. of meetings chaired by CPO" and "no. of meeting attended as a…
-
Why does the Sheet Summary SUMIFs formula show a different result than my report?
I am using this formula to report the total $ amount of past due projects, which rolls up to a dashboard for our team. =SUMIFS(Fee:Fee, [Key Deadline]:[Key Deadline], <=TODAY(), Status:Status, "1-Pre FMV Info Request") + COUNTIFS([Key Deadline]:[Key Deadline], <=TODAY(), Status:Status, "2-FMV In Process") + COUNTIFS([Key…
-
SUM IF issues
Hi friends! I need help with my SUM formula - =SUMIF({Opens RMT Range 1}, "Yes", {Opens RMT Range 2}, "Requested", {Opens RMT Range 3}) What am I doing wrong? I get #INCORRECTARGUMENT Ty!
-
Could a referenced cell formula be messing up my SumIf Formula?
I have two sheets. Sheet A with a list of Projects, Project ID, and Amount of Funds awarded. Sheet B contains order information. The information is taken through a FormStack Form, but on this form, the project owner selects their project name that is basically a list of their project combined with the project ID. Once that…
-
SUMIFS for a 2-Dimensional Array
Hi there, I've got a sheet [Sheet A] that needs to summarize another sheet [Sheet B], where each row on Sheet A needs to reflect a column on Sheet B. I can do this very easily with a SUMIFS function. e.g. Sheet A Row1 =SUMIFS({Sheet B column 3}, {Sheet B column 1}, "example", {Sheet B column 2}, true). The issue with this…