x posted https://www.mrexcel.com/board/threads/construction-budget-distribution-using-gammadist-function.1255570/
and https://www.excelforum.com/excel-general/1421020-construction-budget-distribution-using-gammadist-function.html
The formula doesn't work as the filter function returns an array & countifs needs a range.
However you can use countifs like
=COUNTIFS(INDEX('Raw data'!$E$3:$P$72,,XMATCH('Working sheet'!G4,'Raw data'!$E$2:$P$2,0)),">0",'Raw data'!$B$3:$B$72,"Inactive")
You could try
=FILTER(CHOOSECOLS(Transactions,1,2,match(a1,Transactions[#Headers],0)),((ISNUMBER(SEARCH(" Ending Balance",Transactions[Transaction]))))*(Transactions[Carter Scholarship - Sloan]<>0))
Excel sees both b & c as an array, which sequence doesn't like.
One option is to use
=LET(a,VALUE(TEXTSPLIT(A1,,"-")),b,INDEX(a,1,1),c,INDEX(a,2,1),d,c-b,SEQUENCE(d))
Cross posted
https://www.mrexcel.com/board/threads/help-with-formula.1198426/
and
https://www.excelforum.com/excel-formulas-and-functions/1373123-i-know-this-will-be-easy-for-most.html