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 there, i need to put in a formula, that doesnt count duplicates but can filter on a criteria and count the sum of numbers in a column.
Solved by S. W. in 20 mins
LOOKING TO ADD IN COLUMN IF A, PLUS WHAT IS IN COLUMN B MATCH THEN +1 TO COUNT IN COLUMN C.
Solved by M. S. in 15 mins
hello I am trying to present some data in a stacked column chart - as an example I have two data inputs - unsafe and total observations - I am trying to demonstrate how many unsafe there were in the total count - excel keeps on adding the two together when stacked - if I have 40 total - and I have 20 unsafe the total should still be 40 - rather than 60 as currently the case
Solved by C. L. in 21 mins
would like to subtotal total invoices by territory, however count the numbers of sales reps per territory, as in remove duplicate names but count ALL their sales.
Solved by G. Q. in 18 mins
Need to match sheet #1's column "QTY Count" to Sheet 2's "QTY Count"
As while using sheet one yesterday and using autosum it changed all values to "1" I need the counts excel from sheet 2 to go to the respective locations on sheet 1.
Solved by Z. U. in 28 mins
Trying to group a column and count how many groups exist
Solved by G. J. in 26 mins
I want to count the WINs, OTMs and TIEs from Sheet One where date criteria meets in Sheet Two.
Solved by F. F. in 22 mins
I need a formula that helps me count how many car models (E.g. WU710L-HKMQJ3) there are, but that are also older than 5 years (cell E5) (E.g D5 should be >2012)
Solved by Z. F. in 18 mins
I need a formula that will tell me how many total shares were for articles that were less than 1000 words and for greater than 1000 words. I have one column with the total number of shares and another with the total word count.
Solved by X. Y. in 23 mins
Thanks for that although I couldn't get it to work, I have copied an example below in which I want to count how many "1" or "1a" "1b" or "1c" appear in row S - i currently use COUNTIF(marksheet name!S$2:$S251,"1?") but that only counts the cells with a a,b,or c at the end not the whole number cells, hope i'm making sense.
A B C D E F G H I J K L M N O P Q R S
name 1 F 9KN 9A5/En 17/18 BOSCOBEL K Y 92 L 3 8.85 2.8 1A 1 1
name 2 M 9AP 9A3/En 17/18 ATTINGHAM N Y 96 L 4 14.2 4.7 3A 3 2C
name 3 M 9FR 9A3/En 17/18 ATTINGHAM N Y 96 M 5 16.9 5.6 4A 4 2C
name 4 F 9FR 9B4/En 17/18 ATTINGHAM N Y Y 100 L 4 14.6 4.9 3A 3 1B
Solved by V. L. in 14 mins