Trending in Formulas and Functions
-
Help to count data
We have lot of tasks completed on different months on that how to calculate number of tasks completed on specific month for example on Month July 2023 with a condition that value shows Current=YES.
-
Formula Issue
Hi all, I am trying to average the values in a column, 'Defective Quantity', when the value in column 'hide' is an '11' (for month) AND the data in column 'Year' is 2023. =AVERAGEIF([Defective Quantity]:[Defective Quantity], hide:hide, =11, year:year, =2023) I am receiving an #UNPARSEABLE error. Any idea what I'm doing…
-
Marrying three formulas together
I have three different formulas, containing various criteria, which I want to want to marry together and for which all things must be true: 1) project start date is less than 1/1/24; 2) go-live date is greater than 12/31/23 and 3) the project stage is "In progress" or "Waiting to start": =COUNTIF({HR Projects Project Start…
