Sign in to join the conversation:
Hi
Is it possible to sum the counts of specific cells on different rows in the same sheet.All the cells are in the same column.
Thanks
Mcneil
Check out the =sum formula which will let you sum any numbers in any row or field. Just indicate it in your formula.
=sum([column title]row#, [column title]row#, [column title]row#) Will sum individual cells.
=sum([column title]1:[column title]5) will sum rows 1-5 of a column.
=sum([column title]:[column title]) will sum a column but you can't put this formula in the same column because it will create a circular reference and will throw an error.
https://help.smartsheet.com/function/sum
You can also use SUMIF( or SUMIFS( if you are able to establish specific criteria for which cells to add.
I'm trying to do the same thing with the SUMIF formula, but do not want to specify the exact criteria name "Kate Pearson" because the names are fed in through a form. Instead, I need to reference a cell within the row to then calculate the sum of all rows with the same criteria.
Example - I want to sum all donation values in the [$Value] from an employee where their name is listed in the [EEName] column of the same row. I've been able to make this work when referencing other sheets, but I'm having trouble referencing @row and within same page columns.
Here's the formula I think should work: =SUMIF(EEName:EEName, EEName@row, $Value:$Value, 1)
What am i doing wrong?
Hi,
Try something like this.
I think that it's he absolute reference that doesn't work together with the 1 in the end.
What's the number 1 for in the end?
Let me know if I misunderstood what you need the formula to do!
=SUMIF(EEName:EEName; EEName@row; Value:Value)
The same version but with the below changes for your and others convenience.
=SUMIF(EEName:EEName, EEName@row, Value:Value)
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Did it work?
Hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
Hello, I'm working through the writing formulas optional activity and in the 'Nested IF function - Progress Column' task it directs you to put in the following formula '=IF([% Complete]@row = 0, “Empty”)'. However, when I put this formula into the spreadsheet, '04a_Marketing Request Tracker - Formulas', I get an…
Have any of you created a Smartsheet that would show the savings for a project by the month? In other words, if I saved $1200 annually and the project ended in say March, then the savings would go $120 per month, Mar 2025-Feb 2026. I have done it on Excel sheets manually, but I think there should be a way to do it with…
I have had approval workflows and notifications built into a couple sheets for about a year now. In the past month, I am getting a lot of feedback saying people did not receive the email request for approval or notification email. It isn't all the time, just sometimes and there does not seem to be a pattern on which ones…
