Відео

Thanks

I have a sheet like this but in my case: there are 3 Smiths (the name) category (i.e biology, math, and language). I would like to get the count each unique row (count the "x") for example smith language has three row of absence in this sheet (3 rows which has "x" to count). Please enlight me brother

Unbelievable, I have been struggling with this all day. Thank you Alan.

you save my life, thank youu

Best to clear your throat BEFORE you record a video, otherwise very irritating!

Perfect! Just what i needed

🙏🏻🙏🏻🙏🏻

0:35 Interesting to see the inside of the First Presbyterian Church. I have seen the outside many times from Bedford Street, I call it the fish church, but never went inside.

Amazing

Thank you so much!

how did you get the FUNCTION ARGUMENT window to show up?

Thanks so much ❤ it worked and in such less time😅 great vid🎉

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!

Hi, at 3:27 of the video, does the bracket need to be {"abs","late","ills"} or can the bracket be ("abs","late","ills")?

Hi, at 3:27 of the video, do we need to place sum() around countifs(B7:AD7,{"abs","late","ills"})? Can we just type countifs(B7:AD7,{"abs","late","ills"})?

it helps, thank you :)

Thank you!!

Far too many Churches.

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

Useless, Thank you

useless

Thanks for the upload

This formula is woking in Excel, But not in Google sheets. How can I make it happen in google sheet ?

Good Upload 👌

Much love Buler. Or what ever your name is. Good info. thank you!

Its work sir

Useless, Thank you

useless

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

ua-cam.com/video/811fooFk1MY/v-deo.html

Is it possible formula for count of RAM and HARI =sum(countifs(A1:A12,("RAM","HARI")))

This is not Microsoft 365

Useless.

how do i type “5,5” without an error using IF formula?

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!!!

Thank you very much!

What makes the trains move. Ours doesn't. Santa spins n lights work but all levels of trains have stopped rotating

If row counting wrong by automatic how should correct

thank you so much

Do you think you could have went any faster with those pictures

How to include the blanks??

Do you know if for google sheets is different? It's not working for me

1:12 how ???? Mine didn't show up