Комментарии:
Hello Sir, how to use "countif" if the column has formula?
because it does not count if it has a formula
thanks!
it does not work
ОтветитьVery helpful video
ОтветитьDoes * works with other formulas? Whats the difference between with “” and not having it? I only use “” when using iferror command
ОтветитьHELP!!!! I am trying to use the countif function and I can't figure out what I'm doing wrong. I have a column, Column N that holds my dates my students completed their job shadow. It's marked as mm/dd/year, ex. 09/08/1972. Rows 1 & 2 have headers and I want the total to appear in Row 2, Column N. I use =countif(N3:N56,"*") and it gives me 0. The number 8 should appear...what am I doing wrong?!
ОтветитьI really learn so much with your videos very well explained, THANK YOU!
ОтветитьI want to create a subtotal of a column of data based upon the color of it's description criteria using your COUNTIF formula but can't quite find an example. For example, if I have a spreadsheet of counts for white and brown eggs for everyday of the month of May, I want to first sort the brown eggs and then produce a total at the bottom of the column. I have 4 column headers. Eggs, Date, Quality, Quantity. At the top of the first column it says eggs. The data under the column heads, date, code, and quantity is not in color, only the column "eggs". In that column it either says "white" or "brown." Brown eggs get a quality code. 1-10. White eggs get a quality code 100-110. The "Brown" description cell is orange. The "White" description cell is yellow. So I do a sort of just the color orange for all the brown eggs with b, c, and d in normal sort positions. Now I have my brown egg counts isolated at the top of the sheet. However, I want my summary at the bottom of the quantity column to give me subtotals at the bottom of just the brown eggs in a row, that are colored orange. How can I accomplish that?
ОтветитьWow thanks bro, youve literally saved me hours of work. Its not that I didn't know the formula, but I was underperforming it. I didn't know that the "range" could deal with multiple sets of data at once. I was using this function for each row for thousands of samples instead of using the "range" to combine everything and calculate a full table of data in one cell....not sure if you get me, lol but thanks this helped
ОтветитьThank you for the awesome tutorial!
ОтветитьYou are brilliant. You,be very helpful to for almost 3 years now. 👍😎
ОтветитьCan you use countif(s) within pivot tables?
ОтветитьThank you very much. Very helpful
ОтветитьI'm confused no matter how i do this my countifs function results to 0 how do you decide whats equal to and greater than or less than and i see 400 how did you get that what steps am i missing here help
ОтветитьThank you, well explained...Now to put in to practice.
ОтветитьYou could not ask for this to be any clearer. Thanks!
ОтветитьNICE
Ответитьnice job. this really helped with my spreadsheet for work. i had 2 sheets that didn't balance...i suspected the 300's were the difference...actual error was 299.20 . used the countif to work out one sheet had 41 on, other had 42. not only was this quicker , it was far more accurate than if i'd done it manually. very useful trick as i often get this type of issue. ( having found the big diff, i then zero'd in on the smaller diff of 0.80 soon anyway ! :) )
ОтветитьGreat
Ответить👍
Ответить