Trending in Formulas and Functions
use a reference sheet to gather data for another sheet the rows will differ between 2 sheets
Hi All, I've been pulling my hair out and I'm hoping someone has advice. Bing Copilot is running me in circles because it doesn't understand. I have a sheet with SAP appeals that all steps have been completed (SAP completed sheet) going forward in the example. If the student turns in an appeal to the decision then they are…
Unparseable countifs error with date
=COUNTIFS([RACD]:[RACD]), DATE(24, 06, 30), [VPO/ED]:[VPO/ED], "Misterly" Trying to count number of accounts with an RACD Date of 06/30/24 assigned to VPO Misterly using the above formula and i keep getting an unparseable error. What am i doing wrong
Summary formula vs Column formula: Incompatability issue?
I have several grid sheets that have SUMIF summary formulas running. I’m working on a new sheet that requires I split the date & time that are included in one column. Summary formulas I would ordinarily run on the Program Start Date no longer work. Am I correct in assuming the summary formula will not operate on a column…