Get instant live Excel expert help with a COUNTIF Functions

I need help with COUNTIFS formulas. Expert required only

Solve an average size - want to look at name on tab QScorecard B3, then look at the data tab - needs to sumifs ( new/existing business) column C, and Column D = Closed won and return ($$$$) then also countifs same criteria but solve ($$$$)/ count to give us the Average size

I need a formula that will count the number of text events in tab 1, column BN, between two dates (j field to the right vs. tab 1, column E). I cannot get the countifs function to work...

hello I keep getting " this formula is wrong " message whenever I'm trying to write COUNTIFS , and I'm sure I'm writing the write formula

I need help creating the output for a table. I believe I can use a ISNUMBER(SEARCH()) or COUNTIFS() formula but I am not sure

I need a countifs formula for text values that ignores duplicate values but I can attach other countifs criteria to

I need help with countif google sheets. I need formulas that will dynamically update as new sheets are added to the workbook. I think they will be multi-variable COUNTIFS statements.

I need help creating a COUNTIFS formula that dynamically updates when new sheets are added.

Hi, I'm trying to create a football table that takes the data directly from the scoresheet. Eg Team A beat Team B 3-2. Therefore, I want the table to show Team A have won that game and that Team B have lost it. If they draw, I want it to show that too. I think it's COUNTIFS but I'm not sure how to use it... help please!!!

i am using a countifs formula to find a value that meets the criteria between a date rage and a specific value. however the specific vaue is from another formula =left & =right so it comes back as #value!