How do I count the number of filled-in rows of a sheet based on the contents of a column?

Question

Disclaimer: I am completely self-taught in google sheets

I have a sheet with columns for Date, Place, Title, etc. I am attempting to count how many rows have all their cells filled out, but only want to add up the rows within a certain time period (i.e. based on the "date" cells, which are column A.)

=SUM(ARRAYFORMULA(AND(
                      ISBETWEEN(A9:A,DATE(2022,1,21),DATE(2022,4,1)),
                      ISTEXT(B9:B)=ISTEXT(C9:C)=ISTEXT(D9:D)=TRUE)))

Currently I have this formula, which relies on an "AND" function to check that both the "ISBETWEEN" and "ISTEXT" criteria are met. However, I think this is keeping "ARRAYFORMULA" from working (I originally used "SUMPRODUCT", but that didn't work either.) If that isn't the problem, the fact that the different references aren't somehow logically connected makes wonder if this would method would even work to begin with... So, what functions could I use to accomplish my goal?

I would prefer to contain all of this in one formula, but at this point I'd be fine utilizing a separate hidden sheet if what I'm doing isn't possible in just one cell.

(I've done my best to try and find if this has already been asked, but honestly I'm not sure how to properly phrase this, so sorry if this is a duplicate.)

Answer 1

try:

=COUNTA(IFNA(FILTER(B9:B; B9:B<>""; C9:C<>""; D9:D<>"", 
 A9:A>="2022-1-21*1"; A9:A<="2022-4-1"*1))

or use:

=SUMPRODUCT(B9:B100<>""; C9:C100<>""; D9:D100<>""; 
 A9:A100>="2022-1-21"*1; A9:A100<="2022-4-1"*1)