Get instant live Excel expert help with COUNT Function
“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
Hi, Im looking for a formulae where i want to count mutliple text in one cloumn. Example in a coloumn I Have Yes, No, NA and i want the count of Yes and NA
Solved by X. D. in 13 mins
In Cell H7 of "Lender Loan Tape Summary", I need to use the Google Sheets formula "COUNTUNIQUE" to count the unique zip codes in Column F of "Historical Loan Tapes" tab, per each lender specified in cell B3 of "Lender Loan Tape Summary". I think that COUNTUNIQUE can be used with an Array formula to solve this problem but I am unsure of how to combine COUNTUNIQUE & Array formula.
Solved by G. J. in 23 mins
I am looking to create a summary report from various spreadsheets, and need to create a "counter" based on an "if, then" formula.
In a column I have generated a series of numbers and want to count how many of those numbers are greater than 1 and then put the result (ie. total of 10 cells have a total of greater than 1 into the summary report.
how would I do this?
Solved by I. Q. in 23 mins
I need a formula to count the number Yes's in a column that can be "Yes" or "No"
Solved by K. E. in 26 mins
Hello Hi need help with conditional formatting.. Lets say i have ($100 on cell A) ($200 on cell B) ($300 on cell C) ($0 on cell D) and ($50 on cell E).
How can i add a conditional format rule to cell A that if row B through E has a lesser dollar amount, Cell A would be highlighted? also cells with $0 amount would be ignored and not counted as a lesser amount anything above $1 would count.
Solved by Z. A. in 13 mins
I would like continue going over the first chat session. I need to track down in the same column jobs that are on time, late, and done before the due date. I've used NET WORKDAYS function and included a -1 so that it doesn't count the start day. However, this formula doesn't work with all the project status (on time, late, done before due date). I have over 3,000 records and I need to make sure each record is correctly calculated. Help!! See attachment.
Solved by G. H. in 15 mins
i need the formular to count how many times a name appears on a spread sheet
Solved by A. L. in 18 mins
I need to count blanks and add numbers by giving them aend and a start
Solved by M. U. in 30 mins
I need a formula to count the number of members from a list of cells
Solved by Z. J. in 19 mins
i have a list of names and dates and i want to find the number of occasions each name occurs, for example if name1 happens on 3/10/18 3 times it should only count it once
Solved by K. L. in 30 mins