Get instant live expert help on I need help with excel count filtered rows
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Finding averages using count IFs in a filtered list
Solved by F. W. in 22 mins
Create % of unfiltered total in Excel. I'm trying to calculate a % of total from the unfiltered total rather than the filtered total. So I have four rows like this unfiltered:
Solved by S. H. in 30 mins
On the FILTERS tab, I am trying to figure out how to only count those items that are filtered. Right now it it is capturing the count of all of the cells, rather than the filtered cells.
Ex: on the "CUSTOMER LIST & CODES" tab, if I filter column E to only show branch 5, the count in column B of the FILTERS tab, still shows all of the cells, rather than JUST the filtered cells.
The filtered data is also desired for Column E on the FILTERS tab, too.
The second question: how do I split the sheet so I can see the CUSTOMER LIST & CODES sheet & FILTERS sheet on teh same page?
Solved by X. J. in 15 mins
I need a formula to count when numbers are not equal.
I have 2 columns of cells, 20 rows high, I need to count how ,many times the rows don't match.
Ex. row 1 If c4<>b4, count 1, if c5<>b5, count 1, if c6<>b6, count 1......So if in the 20 rows I have 5 rows that don't match, count 5.
Solved by G. E. in 23 mins
Can you make the formulas be able to be filtered by date? I have columns that count orders, sum quantitiy, and sum revenue. But I'd like them to be able to be filtered by date. So they change if I only ask for Jan - March 2018. Thank you!
Solved by B. E. in 29 mins