-
SUMIFS keeps returning 0
I'm trying to display a sum of the column Total Funds Available when Status = Apps Open, and Value Score = 5. Here is the formula I have: =SUMIFS([Total Funds Available]:[Total Funds Available], Status:Status, ="Apps Open", [Value Score]:[Value Score], ="5") There are rows that meet these conditions and should display a…
-
Formula to sum children rows into parent row
Hi Is there a formula to add up total hours for children into Parent row cell? Also to add earliest local start time and earliest local finish time in parent header?
-
SUMIF OR SUMIFS
I hope I can explain this correctly. I have three separate columns I am working with. My goal is to sum the total footage of certain rows that have been approved within the last 7 days. My columns are: FOOTAGE, STATUS, and DATE APPROVED. I would like to have a total in a separate cell at the top of the sheet. I keep…
-
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…