Hello all! First post here and excited about the wealth of info on this board...
Anyway, I'm performing conditional summing / counting on a spreadsheet that retrieves raw data downloaded from an AS/400. The range of rows varies based on what I'm looking at (account numbers, customers, etc.). Here's what I have so far:
{=COUNT(IF('Raw Data'!$C$2:$C$1752<=B5,'Raw Data'!$C$2:$C$1752))}
The problem I have is when I look at data that has a row count greater or less than 1,752. If I do a conditional count where I only have 440 cells, the formula looks at the blank cells and retrieves an incorrect answer. So, how do I ignore blank cells in this formula.
Thanks!
Anyway, I'm performing conditional summing / counting on a spreadsheet that retrieves raw data downloaded from an AS/400. The range of rows varies based on what I'm looking at (account numbers, customers, etc.). Here's what I have so far:
{=COUNT(IF('Raw Data'!$C$2:$C$1752<=B5,'Raw Data'!$C$2:$C$1752))}
The problem I have is when I look at data that has a row count greater or less than 1,752. If I do a conditional count where I only have 440 cells, the formula looks at the blank cells and retrieves an incorrect answer. So, how do I ignore blank cells in this formula.
Thanks!