Formulas and Functions
Archives for March 2018
Discussion List

SUMIFS Formula Needed for Multiple Calculations Summing from the Same ColumnIn Formulas and FunctionsI am working on a budget sheet, and need to be able to calculate OPEX expenses per site, and CAPEX expenses per site. I've got 6 different sites, and need these totals for each quarter. The formula below seems to work, but I can't use it…

How do I  formula quesIn Formulas and FunctionsI have a formula =COUNTIF(Age8, >65) which is working, but I want it to only give me a count if a certain checkbox field is checked. Is there a formula for this?

UPPER formulasIn Formulas and FunctionsIs there a way to set a formula so all text in the column or sheet is upper case even if someone enters it on a form in lower or title case?

Countif with CheckboxesIn Formulas and FunctionsI need help doing a countif with checkboxes. I have a formula I need to countif in column Project if it has a value of Yes and column Parent Task is check. I also need it to countif column Project also has a value of partial. This for…

Issues with the new cross sheet formulas?In Formulas and FunctionsMy totals were working finally on a summary sheet but then all the columns started changing to the same formula. I tried twice to go in and reset the reference sheet range but then it would just everything on the sheet. Anyone else have …

Is there a way to NOT auto number the 1st Row? ...and other SUM row questions.In Formulas and FunctionsI am using the first row for totals and it is throwing my auto numbering system off. Is there a way to have the auto number start on row 2? Alternatively, if I put my totals on the last row, the web form will populate new rows below my tot…

Checkbox questionIn Formulas and FunctionsIs there a way to have a checkbox automatically checked if other columns with checkboxes get checked? I have 4 columns with checkboxes and instead of doing value columns for each one I would like to do a summary checkbox and just value on…

What would the formula be for.....In Formulas and FunctionsI need to sum or count the number of people in my sheet that are under 17 and over 65, based on who is checked. Can I do this using a cross sheet formula so all my totals are together? I have both DOB and age columns  can the formula be…

Cross sheet formula  helpIn Formulas and FunctionsWith this new feature I'm hoping I can eliminate abut 10 columns from one sheet and create a sheet just for totals. Currently I have several columns just for counting the value of columns with checkboxes. Do I have to leave these in the…

=If FormulasIn Formulas and FunctionsHi! I am attempting to create an "=If" formula that has 21 "if_then" statements. When I get to the end my formula enters as "Unparsable." Is there a limit to criteria in a formula? Thanks!