Комментарии:
How did you create Column A static column
ОтветитьThank you Sir!
ОтветитьHello! How do you make to show you the dates that they were absent, for example? I really need this formula and I don't know how to write it, thank you!
Ответитьit helps, thank you :)
ОтветитьJust what I was looking for. Thanks Alan
ОтветитьWhat if the rows have a drop down list? How would the formula change? Thanks
Ответитьthat dude is simply the best, many thanks to the universe that you man exist 😎 🍻🥳
ОтветитьYou are a legend, I subscribed
ОтветитьThis formula is woking in Excel, But not in Google sheets. How can I make it happen in google sheet ?
ОтветитьGood Upload 👌
ОтветитьHi I tried to use the countif function like you did in this video. Then I tried to define specific columns for the function but excel wouldn't let me select more than 3 ranges of columns. Is there a function that will allow me to get around this problem and be able to select and count words in multiple columns?
Ответитьthanks alot
i have in shifts shudle rota that has in row 6 the dates and my imployees works some times in weekends . how could i count by formula the days they work on weekends for trible fee. i wrote this formula but it dosent worked : my imployyes names start at A8 to A15 and the letter W is for work day ; and the dates from B6 to AF6: countifs( C7:AF7,"=W", B6:AF6,"weekday($B$6,1)>5")
our weekend is friday and saturday.
so what is wrong with my formula and how it should be ?
thanks in advanced
Is it possible formula for count of RAM and HARI =sum(countifs(A1:A12,("RAM","HARI")))
ОтветитьHi its amazing but what if i use two arrays for example =SUM(COUNTIFS(Y:Y,{"5,000 - 9,999","10,000 - 19,999"},Q:Q,{"Denmark","Finland","Iceland","Norway","Sweden"})) i am not getting exact result can you help ?
ОтветитьThank you!!!
ОтветитьIf row counting wrong by automatic how should correct
Ответитьthank you so much
ОтветитьHow to include the blanks??
ОтветитьDo you know if for google sheets is different? It's not working for me
Ответитьi want to count the words like ("PL","HOL","CFL") appearing in a row if the date on the other row is greater than today()
also if the date is less than today()
Thanks a ton! <3
ОтветитьThank You so much, was missing the curly brackets.
ОтветитьThanks a lot
ОтветитьDeyymm. You saved me bro. Thanks for this
ОтветитьSoooooo does anyone know how to count values only once for this equation and not count duplicate values?
ОтветитьThis is what I want
ОтветитьThanks, it's very useful
ОтветитьPlease can u share in google sheet too. Since this doesn't work in google
ОтветитьThank you for this video! It is very very helpful!
ОтветитьThank you so much...
ОтветитьI'm going crazy, how do I count how many people were either rejected or accepted for either a manager position or junior position on a specific day i.e. how many people were rejected for the junior position on 01 January? I've tried sooo many different formulas and none are working.
ОтветитьThank you soo much it helped me alotzz though I was nt interested in computer back then in school lyf I had to do now bcoz of the job I have …. thanks
ОтветитьThanks 😊
ОтветитьHow I can get final average in this
Please tell me
That was great. Thank you!
ОтветитьWhy isn’t this working for me in my google sheets ! 😢
ОтветитьIs there a way to highlight the countif results in the original data?
EG: Smith missed the Oct 11th then that day would be highlighted in the table based on the countif criteria
Thank you so much. SUM before countifs and the curly brackets. Genious
ОтветитьIts Really Amazing!! I'm just looking for like this. Thank you so much.
ОтветитьThanks for your very helpful video ...
ОтветитьThank you!
ОтветитьThank You so much for this!!! This exactly what i have been trying to accomplish for weeks !!
ОтветитьHi! what if you have for example a "key table" L or C then a number that is a free form. Can I email you what I'm talking about? I really need help :(
Ответить