Trending in Formulas and Functions
Countifs drop-down multi columns
Hi, I'm unable to get countifs results on this sheet where GEO is drop-down list column allowing for multi values and STATUS is a drop-down list allowing single values. I'm looking to count the number of values GEO if the STATUS is COMPLETE. In this case: EU, COMPLETE (2) US, COMPLETE (1) AFR, COMPLETE (1) Any idea how to…
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.
SUMIFS Summary Formula Issue
Good afternoon - I am trying to create a summary formula that sums the values in the range from Shared Inboxes to Metrics if the Date column is between 11/1/23 and 11/30/23. I've created the following formula; however, it's returning #INCORRECT ARGUMENT SET. Any suggestions? Thank you!! =SUMIFS([Shared Inboxes]:Metrics,…