Comments
-
嗨凯莉!那nks for looking in to this for me! We're getting closer - the final step is to remove / Reports, and / Autoimport in the case of this screen shot: i.e., not joining together the ancestors, but just keeping the parent row, that being just Synergy. Here's the formula I have that yields what is displayed:…
-
=SUM(VALUE([Formula - Work Experience 18-19]@row:[Formula - Work Experience 21-22]@row)) Gives me "INVALID DATA TYPE"
-
Many thanks for your response! I actually found a way to do this in addition to the way you cited. Here's what worked on my end: =MIN(40, (SUM([Formula - Honor Society 2018-2019]@row:[Formula Volunteer Activities 21-22]@row))) Thanks again!
-
Hoping there is a "not to exceed" function?
-
Good question - the formula now yields 56 on the sheet and only needs to be displayed on the sheet. So, if the responses the applicant only calculate to 38, I want the formula to display 38 - but, if they calculate to 44 for example, I only want the formula to display 40. i.e., anything in excess of 40 would not be shown…
-
Fantastic! Thank you, much appreciated!
-
It sure does! Thank you! Now, I want to add vertically, which I know I can do with this formula when the cells are all in a row: =SUM(COUNTIF([Minneapolis Task Complete]2:[Minneapolis Task Complete]4, 1) / 3) However, what if I want to add cells that are not in a consistent row? In this case, I want to sum rows 2 and 4.…
-
THANK YOU!! I never cease to be amazed - this worked!! Thanks for the HAS function! :)
-
那nks Paul, I did notice that error after I sent my last comment, but I still get the #UNPARSEABLE response. Interesting thing, when I copy that formula out of the cell in Sheet Summary, it does not color the different columns like other formulas do. =SUMIFS([Estimated Project Work Hours]:[Estimated Project Work Hours],…
