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.
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…
If 2 Criteria Met On Second Sheet, Display ID Number from Second Sheet on First Sheet
I am trying to write a cross-sheet formula in sheet 1 (field name is Row ID) to display the Row ID from a second sheet if the second sheet Newest field and ED field are both checked (see below). I've been looking through posts and attempting INDEX/MATCH, nested IFs, etc. and nothing is working so far. Any help would be…