sumifs - Robuta Search

https://community.smartsheet.com/discussion/97244/sumifs-countifs-date-issue SUMIFS/COUNTIFS Date Issue - Smartsheet Community Hi all, I am attempting to create a formula to add up all the Employees from a sheet from last month. This sheet is pulling in totals on an automation monthly.... sumifs countifs date issue smartsheet https://community.smartsheet.com/discussion/42436/sumifs-formula-unparsable SUMIFS Formula unparsable - Smartsheet Community Hello, My formula below keeps coming back unparsable and I can't figure out why...The column I need to be summed is referenced first in Range 2. I am also... sumifs formula smartsheet community https://community.smartsheet.com/discussion/97519/sumifs-returns-a-0-s-b-an-amount-once-there-are-oct-2022-2023-entries-in-a-date-range SUMIFS returns a $0 (s/b an amount) once there are Oct 2022 & 2023 entries in a date range -... Aloha, I have a SUMIFS formula that works until I have Oct 2022 and Oct 2023 entries in the date range. Then Oct 2023 returns a $0 when it should return an... https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Power-BI-SUMIFS-on-another-table/m-p/2712724/highlight/true Solved: Re: Power BI SUMIFS on another table - Microsoft Fabric Community Aug 23, 2022 - Thank you, I thought about it but I would like to do it in DAX. I dont find the equivalent of MAX for Double, you know when you make column_values = power bi microsoft fabric solved sumifs https://community.fabric.microsoft.com/t5/Desktop/New-Column-like-SUMIFS-with-multiple-matching-columns/td-p/2667213 Solved: New Column, like SUMIFS with multiple matching col... - Microsoft Fabric Community Jul 28, 2022 - Solved: Hi all, I really struggle to make a needed SUM column which is based on multiple criterias one of them being a Date/Month-column. My dataset new column https://community.smartsheet.com/discussion/122419/sumifs-count-is-off-from-column-sum-count-how-can-i-fix-this Sumifs count is off from column sum count. How can I fix this? - Smartsheet Community I am attempting to match my sheet summary with the column sum of 1115 (seen at the bottom). The sheet summary is pulling the column "Fiscal DOD K-6 Hours" as... https://community.smartsheet.com/discussion/106419/sumifs-not-working-referencing-another-sheet SUMIFS not working (referencing another sheet) - Smartsheet Community I'm struggling with getting a SUMIFS function to work properly that is referencing another sheet. So on my sheet with the function, I have it as:... not working sumifs referencing another sheet https://community.smartsheet.com/discussion/107288/sumifs-with-variable-criteria-analyzing-data SUMIFS with variable criteria - analyzing data - Smartsheet Community I have a worksheet that is populated by way of a 'form'. There is a small snapshot of my worksheet below. Some how I need to sort by 'PC #', Sum Total Invoices... analyzing data sumifs variable criteria smartsheet https://community.smartsheet.com/discussion/87493/sumifs-with-and-and-or-criteria Sumifs with AND and OR Criteria - Smartsheet Community Hi, I'm trying to collect a "Total Amount" if the following criteria is met: * The "Category" is "Banking" * The "Owner" is "Resident" * The "Account Type" is... sumifs criteria smartsheet community https://community.airtable.com/base-design-9/summarize-data-for-reporting-in-excel-would-use-sumifs-summing-data-on-different-sheets-29144 Summarize Data for Reporting (In Excel would use Sumifs summing data on different sheets) |... Hello, I am using AirTable for my plumbing company workflow. My base is currently set up with a table for Jobs (each record is a single job with info li... https://community.smartsheet.com/discussion/101209/using-column-formulas-for-countifs-sumifs-evaluation-arent-working Using Column Formulas for CountIfs / SumIfs evaluation aren't working - Smartsheet Community I have a sheet for Test Scripts. In this sheet we have an AutoNumber column so we have a fixed ID. We also have a calculated column with the ID and the Name.... https://community.smartsheet.com/discussion/44211/sumifs-help-please SUMIFS Help Please - Smartsheet Community Hi, I need help for a simple formula. I emailed Smartsheet support a month ago but never got an answer. I want to total how much has been spent by budget type... help please sumifs smartsheet community https://community.smartsheet.com/discussion/77065/struggling-with-a-sumifs-date-range-formula Struggling with a SUMIFS date range formula - Smartsheet Community For this use case, I need to sum the total hours (Range 3) for every entry that has a date between January 1, 2021 and January 31, 2021 (Range 1). The formula... with a date range struggling sumifs formula https://community.smartsheet.com/discussion/106961/using-sumifs-formula-with-contains-or-has-as-criterea Using SUMIFS formula with CONTAINS or HAS as Criterea - Smartsheet Community I'm trying to only add up budget line items from specific months and that do not contain the value "Total" in their account code. Here's the formula I have and... using sumifs formula contains https://community.smartsheet.com/discussion/102658/why-this-sumifs-formula-doesnt-work Why This SUMIFS Formula Doesn't Work? - Smartsheet Community I'm trying to identify how much Overall Projected Volume will Bill in the Year 2023 for Joe Smith. Not sure why this formula doesn't work? =SUMIFS([Billing... sumifs formula work smartsheet community https://community.smartsheet.com/discussion/47911/sumifs-based-off-status-and-date SUMIFS based off Status and date? - Smartsheet Community I am building a counter for a team where they do a simple web form to say which task they did, and how many times they did it. There then needs to be a... sumifs based status date smartsheet https://community.smartsheet.com/discussion/106971/using-sumifs-formula Using SUMIFS Formula - Smartsheet Community using sumifs formula smartsheet community https://community.smartsheet.com/discussion/114910/sumifs-multiple-criteria Sumifs Multiple Criteria - Smartsheet Community multiple criteria sumifs smartsheet community https://community.smartsheet.com/discussion/113241/sumifs-for-multiple-reference-sheets SUMIFS for multiple reference sheets - Smartsheet Community Hi, I am setting up a metric sheet for a dashboard chart. I am trying to add Revenue for Delivered sessions, Revenue for Expired sessions, and Revenue for... reference sheets sumifs multiple smartsheet community https://community.smartsheet.com/discussion/93486/2-sumifs-not-equal-to-2-variations 2 SUMIFS NOT equal to 2 variations - Smartsheet Community Hello, I've tried the below formula but it doesn't work (instead of SUMIFS A AND SUMIFS B), This works: =SUMIFS(pay:pay, [Code a]:[Code a], [Code a]@row, [code... not equal sumifs variations smartsheet community https://community.smartsheet.com/discussion/26736/sumifs-date-range SumIfs Date Range - Smartsheet Community Hi, I'm looking for help writing a SumIfs formula with one of the criterias being a date range. I'm creating a Time Off Tracking form to track how much PTO an... date range sumifs smartsheet community https://community.smartsheet.com/discussion/83854/using-sumifs-together-with-avg-returning-unparseable Using SUMIFS together with AVG returning #UNPARSEABLE - Smartsheet Community Hello, I am getting the #UNPARSEABLE error in my formula to sum totals between a date range and return the average of the total sum. The formula seems to work... together with using sumifs avg returning https://community.smartsheet.com/discussion/90276/can-a-sumifs-formula-pull-from-data-from-multiple-columns-in-one-row Can a sumifs formula pull from data from multiple columns in one row? - Smartsheet Community Newbie here, trying to get my budget summary sheet to pull data from budget tracking sheet. Currently using a sumifs formula, working fine, however I need to... https://community.smartsheet.com/discussion/58956/sumifs-with-multiple-criteria SUMIFS with Multiple Criteria - Smartsheet Community Hi, I am trying to create a summary formula for Work-in-Progress (WIP) value on a KPI summary sheet, using data on a secondary sheet. I need the formula to do... multiple criteria sumifs smartsheet community https://community.smartsheet.com/discussion/141038/sumifs-formula-help SUMIFs Formula Help... - Smartsheet Community I am trying to calculate a specific persons total numbers across four columns in the Sheet Summary. Below is the formula that I have, but it keeps returning... sumifs formula help smartsheet community https://techcommunity.microsoft.com/discussions/excelgeneral/sumifs-formula-help---multi-criteria-settings-not-correct-/3611477 SUMIFS formula help - multi-criteria settings not correct. | Microsoft Community Hub I have a multi-sheet budget spreadsheet at work. I am trying to total the spend for each department based on a selection of account... microsoft community sumifs formula help multi https://community.smartsheet.com/discussion/112682/sumifs-not-a-specific-contact Sumifs NOT a specific Contact - Smartsheet Community I am really stumped and getting a #Incorrect Argument return I am using a sumifs formula to pull data from another sheet. When I use this formula everything... not a sumifs specific smartsheet community https://community.smartsheet.com/discussion/86108/sumifs-for-entry-date-job-number Sumifs for Entry Date & Job Number - Smartsheet Community I am trying to create a cumulative count of all Piers Completed through a given date respective to a specific job (Job Number) below is the syntax I have so... sumifs entry date job number https://community.smartsheet.com/discussion/97050/sumifs-with-text-and-numbers Sumifs with text and numbers - Smartsheet Community I have this issue I am using a nested if-statement as a column formula where two of the values are sometimes text and other times saved as values. These are... text and numbers sumifs smartsheet community https://community.smartsheet.com/discussion/47236/sumifs-with-cross-sheet-date-ranges SUMIFS with Cross Sheet Date Ranges? - Smartsheet Community sumifs cross sheet date ranges https://community.smartsheet.com/discussion/130700/how-do-i-have-sumifs-equation-that-tracks-if-both-contribute-new-to-new-and-renew-to-renew How do I have sumifs equation that tracks if=both contribute new to new and renew to renew -... We need to find out how to implement whether the equation is Both and how to associate new + renew. https://community.smartsheet.com/discussion/70671/sumifs-question Sumifs Question - Smartsheet Community sumifs question smartsheet community https://techcommunity.microsoft.com/discussions/excelgeneral/combine-sumifs-function-with-or-function/4110004 Combine SUMIFS function with OR function | Microsoft Community Hub Hello to everyone.I need to create a formula that returns a SUM with different criterias, but I'm not getting it. I have a tableColum 1 | Column 2 |... microsoft community combine sumifs function hub https://community.smartsheet.com/discussion/146460/sumifs-formula-bringing-back-total-of-all-items-not-items-in-specified-date-range SUMIFS formula bringing back total of all items, not items in specified date range. - Smartsheet... Hello, I'm using a SUMIFS formula to try and get the sum of materials, done during a specific process, during the specified date range of May 04 2026 - May 08... https://community.smartsheet.com/discussion/78371/using-sumifs-with-dates Using SUMIFS with dates - Smartsheet Community Hi, I am trying to create a formula for summarizing data from a time log. I have a row with person's name, auto-generated row creation date and time spent in... using sumifs dates smartsheet community https://techcommunity.microsoft.com/discussions/excelgeneral/combine-sumifs-function-with-or-function/4110004/replies/4110013 Combine SUMIFS function with OR function | Microsoft Community Hub Hello to everyone.I need to create a formula that returns a SUM with different criterias, but I'm not getting it. I have a tableColum 1 | Column 2 |... microsoft community combine sumifs function hub https://community.smartsheet.com/discussion/77389/sumifs-not-working-to-sum-after-a-given-date SUMIFS not working to sum after a given date - Smartsheet Community I am trying to sum a person's allocation if it is after a certain date. They might have 1-8 projects at one time with differing finish dates. I can get it to... not working sumifs https://community.smartsheet.com/discussion/47421/sumifs-calculation SUMIFS calculation - Smartsheet Community sumifs calculation smartsheet community https://community.smartsheet.com/discussion/117479/sumifs-formula-with-multiple-criteria-excluding-blanks SUMIFS Formula with multiple criteria excluding blanks - Smartsheet Community I would like to sum a column, only if another column with dates falls between certain dates, and if another column with dates is not blank. I have the first... multiple criteria sumifs formula excluding blanks https://community.smartsheet.com/discussion/100179/sumifs-returns-no-total-with-one-line-of-data/p1 SUMIFS returns no total with one line of data - Smartsheet Community We are using this SUMIFS and COUNTIFS as part of our caluclations for critical path. They have been working fine for the entire team, except one member who... one line sumifs returns total https://community.smartsheet.com/discussion/57381/sumifs-with-3-conditions SUMIFS with 3 conditions - Smartsheet Community Hi I am trying to calculate the total number of worked hours within a week/ month which match 2 more criteria. At the moment I have fr the monthly formula 9... sumifs conditions smartsheet community https://techcommunity.microsoft.com/discussions/excelgeneral/maximum-number-of-arrays-to-use-with-sumifs/4453457?topicRepliesSort=postTimeDesc&autoScroll=true Maximum number of arrays to use with SUMIFS | Microsoft Community Hub Hi,I have a situation where I need to sum a column where it would be ideal if SUMIFS could use three (or more) arrays in M365. The following sample SUMIFS... microsoft community maximum number arrays https://community.smartsheet.com/discussion/99994/sumifs-referencing-to-same-cell SumIfs - referencing to same Cell - Smartsheet Community Hi Team, I have to calculate a number based on 3 criteria, i tried this formula but it says Invalid: =SUMIFS([Duration Completed]:[Duration Completed],... sumifs referencing cell smartsheet community https://community.smartsheet.com/discussion/138119/sumifs-formula SUMIFS Formula - Smartsheet Community sumifs formula smartsheet community https://techcommunity.microsoft.com/discussions/excelgeneral/problems-with-a-sumifs-formula/4421798 Problems with a SUMIFS formula | Microsoft Community Hub I'm really having some trouble with Excel in that it's not behaving logically. Essentially, what I'm trying to do is conditional sums for spending... problems with microsoft community sumifs formula hub https://community.smartsheet.com/discussion/69765/sumifs-cross-referencing-help SUMIFS Cross referencing Help - Smartsheet Community referencing help sumifs cross smartsheet community https://community.smartsheet.com/discussion/88324/sumifs-with-multiple-criteria-with-one-at-row-level SUMIFS with multiple criteria with one at row level - Smartsheet Community Hi there, Going bonkers trying to work this out...I am sure a simple mistake somewhere, maybe tied to @cell or @row.... I am trying to sum the total of three... multiple criteria sumifs one row level https://community.smartsheet.com/discussion/76073/how-to-use-the-month-function-on-a-sumifs-formula How to use the month function on a Sumifs formula? - Smartsheet Community I have two sheets. Sheet 1 house all hours for all channels. Sheet 2 I need to pull in those hours and calculate them based on two criteria's (channel and the... how to use the month https://community.smartsheet.com/discussion/67563/sumifs-with-additional-criteria SUMIFS with additional criteria - Smartsheet Community Hello, Please can someone help, I am using this formula to add one more criteria but it returns back saying #INVALID OPERATION, the formula works before i... sumifs additional criteria smartsheet community https://community.smartsheet.com/discussion/139348/countifs-sumifs-with-multiple-criteria-which-reference-another-sheet Countifs/Sumifs with multiple criteria which reference another sheet - Smartsheet Community I'm trying to make a Metrics sheet to use on a dashboard. I would like to count all of the instances of each (text) heading which fall during this month, then... multiple criteria countifs sumifs https://community.smartsheet.com/discussion/108006/adding-multiple-sumifs-and-return-is-0-if-one-cell-is-blank Adding multiple SUMIFS and return is $0 if one cell is blank - Smartsheet Community I'm trying to add multiple sumifs formulas together in one formula. However, not all of the sumifs will have an input. Example: Expense tracking, most of the... https://community.smartsheet.com/discussion/58246/sumifs-vlookup-or-date-range Sumifs, vlookup, or date range - Smartsheet Community Hey I have some difficulty figuring out how to write a formula for my problem. My scenario is as follows: I have to sheets (see attached): * Payment sheet *... date range sumifs vlookup smartsheet community https://community.smartsheet.com/discussion/14606/sumif-sumifs Sumif /Sumifs - Smartsheet Community Having trouble getting the sumif function to work. I have tried 2 versions, below =SUMIFS([Days Open]:[Days Open], Location:Location, [Repair Description]17)... sumif smartsheet community https://community.smartsheet.com/discussion/105534/sumifs-with-criterion-range-in-column-with-multiple-entry-options Sumifs with criterion range in column with multiple entry options - Smartsheet Community I track all of our projects on a single sheet, to include opportunities and finished projects. I want to sum the total sold amount. I have a column called... multiple entry sumifs criterion range https://community.smartsheet.com/discussion/33621/sumifs-with-vlookup SUMIFS with VLOOKUP - Smartsheet Community On a sheet I call "Project Group Hour Totals", I am trying to add the hours from a sheet I call "Project Time Tracker", using VLOOKUP to find both my Project... sumifs vlookup smartsheet community https://techcommunity.microsoft.com/discussions/excelgeneral/is-there-an-if-statment-equivalent-to-sumifs/321129 Is there an IF statment equivalent to SumIFS? | Microsoft Community Hub I have a spreadsheet with a tab that has my data in a database format. I need to write an if statement that will search a column of data and... microsoft community https://techcommunity.microsoft.com/discussions/excelgeneral/sumifs-using-indirect-function/4074179 SUMIFS USING INDIRECT FUNCTION | Microsoft Community Hub REQUIRED FUNCTION TO SUM THE MULTIPLE SHEETS USING INDIRECT FUNCTION. microsoft community sumifs using indirect function https://community.smartsheet.com/discussion/98130/sumifs-formula-with-various-criteria sumifs formula with various criteria - Smartsheet Community I was wanting some help with a sumifs formula where I'm trying to sum a qty if another column meets certain criteria and then the date column is between 2... sumifs formula various criteria smartsheet https://community.smartsheet.com/discussion/109122/sum-collect-sumifs-based-on-multi-select SUM(COLLECT/SUMIFS( based on multi-select - Smartsheet Community Hi everyone, Does anyone have a formula already handy that does this? Looking to SUMIFS values where the variable is one of the options in the dropdown value?... based on multi select sum collect smartsheet https://techcommunity.microsoft.com/discussions/excelgeneral/sumifs-formula-help/356240 SUMIFS formula help | Microsoft Community Hub I currently use this formula =SUMIFS(Transactions!$F$3:$F$17,Transactions!$K$3:$K$17,"7508") This will search a worksheet for the number 7508 in a... microsoft community sumifs formula help hub https://community.smartsheet.com/discussion/89560/sumifs-statement/p1 SUMIFS statement - Smartsheet Community Hello, I am trying to use SUMIFS to pull reference a numbers on another sheet. I want to say if the PO number is = X, pull the invoice total from the invoice... sumifs statement smartsheet community https://community.smartsheet.com/discussion/58126/sumifs-looking-for-specific-phrase SUMIFS looking for specific phrase - Smartsheet Community Hi Community, I've been digging to find an answer for sometime now and haven't been able to find what I am looking for quite yet. What I need my formula to do... looking for sumifs specific phrase smartsheet https://techcommunity.microsoft.com/discussions/excelgeneral/sumifs-not-working-with-blanks-/3703053 SUMIFS not working with blanks. | Microsoft Community Hub not working microsoft community sumifs blanks hub https://community.smartsheet.com/discussion/52501/sumifs-based-on-parent-and-children-criteria SUMIFS Based on Parent and Children Criteria - Smartsheet Community Hi there! I am trying to make a master reporting sheet that is just a sum of another source sheet based on specific criteria of parent and child rows. It's a... based on sumifs parent children criteria https://techcommunity.microsoft.com/discussions/excelgeneral/using-sumifs-formula-between-different-spreadsheets-on-sharepoint/3951077 Using =SUMIFS formula between different spreadsheets on SharePoint | Microsoft Community Hub I am trying to reduce manual entry into one Excel spreadsheet by using =SUMIFS formula to get information from 3 other different spreadsheets. When I use... microsoft community using sumifs formula different https://community.smartsheet.com/discussion/90637/sumifs-with-and-coontains SUMIFS with AND COONTAINS - Smartsheet Community Hi. I'm trying to do SUMIFS with AND CONTAINS. The logic is SUM entry from column A(referenced from another page), if Column B(referenced from another page)... sumifs smartsheet community https://techcommunity.microsoft.com/discussions/excelgeneral/nested-if-with-sumifs-conditions/3593065 Nested IF with SUMIFS conditions | Microsoft Community Hub Hello, Below is my formula in excel. The yellow color cell is the data validation list. Could anyone help me check what is going on with the formula?... microsoft community nested sumifs conditions hub https://community.smartsheet.com/discussion/132275/sumifs-within-a-time-frame-to-calculate-total SUMIFS within a time frame to calculate total % - Smartsheet Community Hi I have a rows of start and finish dates and in those dates I have an assigned person with a percentage of capacity or allocation. what I want to achieve is... a time sumifs within frame calculate https://techcommunity.microsoft.com/discussions/excelgeneral/sumifs-with-index-match---or--function/4018472 sumifs with index match & or function | Microsoft Community Hub I am getting a #value! error with the following... microsoft community sumifs index match function https://help.libreoffice.org/latest/dz/text/scalc/01/func_sumifs.html SUMIFS function sumifs function https://community.smartsheet.com/discussion/41976/sumifs-issue SUMIFS Issue - Smartsheet Community Hi, I have a client master list on my Smartsheet and I want to get the total monthly fee of those clients that have an "Active" status Both the monthly fee and... sumifs issue smartsheet community https://techcommunity.microsoft.com/discussions/excelgeneral/macro-to-sumifs-a-range-of-values-based-on-dates/3622629/replies/3622633 Macro to sumifs a range of values based on dates | Microsoft Community Hub I would like to translate the following excel formula to a macro for the sumifs of values based on dates. Currently I am getting an error msg pop up... https://community.smartsheet.com/discussion/119864/sumifs-with-ranges-on-multiple-sheets SUMIFS with ranges on multiple sheets - Smartsheet Community Hi there! I have a metrics sheet that I use to calculate the number or weeks each account manager booked on a given week of the year. The formula I have... sumifs ranges multiple sheets smartsheet https://community.smartsheet.com/discussion/107479/formula-help-with-sumifs-would-like-to-incorporate-an-ifmax-in-there-somehow Formula help with SUMIFS. Would like to incorporate an IFMAX in there somehow. - Smartsheet... Here's the headers in one sheet and a few example rows to picture what I'm looking to do. So project 8 for example might see his engagement go up from Facture... https://community.smartsheet.com/discussion/35961/formula-assistance-sumifs-countifs-of-children Formula Assistance (SUMIFS, COUNTIFS of CHILDREN) - Smartsheet Community I'm having difficulty with a few formulas wherein I'm attempting to SUM and COUNT only the CHILD rows so as to not duplicate amounts or counts (ie. need to... formula assistance sumifs countifs children https://community.smartsheet.com/discussion/19001/using-or-in-a-sumifs-or-countifs-function Using OR in a SUMIFS or COUNTIFS Function - Smartsheet Community Hi Guys, Smartsheet noobie here and I was wondering if it is possible to use a OR in SUMIFS or COUNTIFS function. Basically I want to sum a count values in a... in a using sumifs countifs function https://community.smartsheet.com/discussion/55471/sumifs-returning-invalid-data-type-when-referenced-range-contains-a-formula Sumifs returning #INVALID DATA TYPE when referenced range contains a formula - Smartsheet Community I am creating a per week rollup that shows a sum of the children rows from another sheet. It looks to me like SUMIFS does not work if the range referenced... https://www.w3schools.com/googlesheets/google_sheets_sumifs.php Google Sheets SUMIFS Function Well organized and easy to understand Web building tutorials with lots of examples of how to use HTML, CSS, JavaScript, SQL, PHP, Python, Bootstrap, Java and... google sheets sumifs function https://community.smartsheet.com/discussion/55581/sumifs-for-multiple-criteria SUMIFS for multiple criteria - Smartsheet Community This should be fairly simple, but I am spinning on this syntax. Trying to sum my "Invoiced" column if the Year Column = "2019" and the Type Column = "Expense".... multiple criteria sumifs smartsheet community https://community.smartsheet.com/discussion/7428/sumifs Sumifs - Smartsheet Community Does anyone know how many criterion you can have with a SUMIFS? This formula works =SUMIFS([Conversion to $US]$21:[Conversion to $US]$385, [Cost Centre... sumifs smartsheet community https://community.smartsheet.com/discussion/87850/sumifs-formula-cross-sheet sumifs formula cross-sheet - Smartsheet Community sumifs formula cross sheet community https://community.smartsheet.com/discussion/44186/help-with-sumifs-index-match-formulas Help with SUMIFS & INDEX/MATCH Formulas - Smartsheet Community help with sumifs index match formulas https://community.smartsheet.com/discussion/132321/sumifs-with-criteria-in-2-columns-of-different-sheet SUMIFS with criteria in 2 columns of different sheet - Smartsheet Community sumifs criteria https://community.smartsheet.com/discussion/95833/sumifs-formula-issue SumIFS Formula Issue - Smartsheet Community Hi I need to count the number of total Artefacts if the Process column equals one of four process options. I'm doing this calculation in the Sheet Summary... sumifs formula issue smartsheet community https://community.smartsheet.com/discussion/128424/sumifs-formula-and-blank-cells SUMIFS Formula and Blank Cells - Smartsheet Community We have a formula which will value sales forecasts for this month, next month and month 2. It works fine when the sell value and date columns are all... sumifs formula blank cells smartsheet https://community.smartsheet.com/discussion/97247/i-want-to-avoid-an-error-message-on-a-sumifs-function I want to avoid an error message on a SUMIFS function. - Smartsheet Community Here is the function: =SUMIFS(Amount:Amount, Date:Date, YEAR(@cell) = Year@row, Date:Date, MONTH(@cell) = CurrentMonth@row) This works to tell me the "Amount"... i want to https://community.smartsheet.com/discussion/64934/sumifs-not-working-in-smartsheet-vs-excel SUMIFs not working in Smartsheet VS Excel - Smartsheet Community I have the following table in excel if i use the function =SUMIFS($C$2:$C$5,$A$2:$A$5,101,$B$2:$B$5,"Approval") it will return the value of the approval date -... not working vs excel sumifs smartsheet community