Greetings (and my apologies in advance if I don't describe this well),
I have a large dataset with multiple sheets. The SUMMARY sheet pulls from a table on the WORKING sheet. I need to summary counts from a column comprised of blanks and numbers here's the formula:
=COUNTA(IF(Working!$A:$A=Summary!$A2,Working!L:L))
Summary counts are based on referenced cells from SUMMARY column A [categorical data] matching WORKING column A, and blanks and numerical cells in WORKING column L.
When I perform the array I receive: 1048576 (this is the count of the entire row list, even though my data stops at row 2042)
However when I manually count (using filters) the column of data for the reference category it should be: 2
So my question is: How can I get a valid count without doing manually manipulation? Thanks!
PS I cannot upload this dataset due to sensitive information.
Bookmarks