Sign in to join the conversation:
I 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?
=Countifs(Age:Age, >65, [checkbox column name]:[checkbox column name], 1)
This would count the age over 65 if the checkbox column where there is an age greater than 65 is checked. Checkboxes that are checked have the value of 1, unchecked as the value of 0.
I need this formula to sum cells in a reference sheet based on dates. The reference sheet has a column with dates, and there could be multiple of the same date. I was able to get this formula to work on the top line in the screenshot, but the next line is adding the 2 week ending sums together. The planned bushels for week…
I'm having an issue with this sheet: Smartsheet - Quote The COST / PC column is where the issue is happening. On line 4, I'm testing out using a different material that doesn't conform exactly to the sheet's setup but I'm trying to build in functionality to make it possible. When the columns being added by COST / PC are…
Hi There, I'd like to count the cells which year belongs to 2024, seems the formula I wrote cannot capture the correct volume, may I seek your help for it? which part is wrong in my formula? Details as following: My formula: Reference column: Thanks in advance!
