Excel - COUNTIFS with multiple criteria and OR logic

Excel - COUNTIFS with multiple criteria and OR logic

IF statement to add/deduct points from average

When you use multiple criteria with OR logic, caution is required so that you don't double-count. In some situations it can be easy to accidentally double count by applying criteria that are too loose. I'd suggest doing a double check on a couple of rows (or columns) of data to verify accuracy.

[tim]

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

Thank You so much for this!!! This exactly what i have been trying to accomplish for weeks !!

[gersoncastillo]

Thank you so much. SUM before countifs and the curly brackets. Genious

[carmenicas]

This is the best thing in the world. THANK YOU!

[juliusyorke]

Just what I was looking for. Thanks Alan

[grubershmuel]

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?

[Steave-M]

You are amazing, you saved my life with {...} Thanks a lot we need more videos like this please

[mohammadsaifulislam]

Its Really Amazing!! I'm just looking for like this. Thank you so much.

[aysinsoytekin]

Thank you for this video! It is very very helpful!

[ManiacGamerMo_loud]

Can I do it with multiple ranges rather than criteria? It would useful for me and thanks.

[mihailshevchuk]

that dude is simply the best, many thanks to the universe that you man exist 😎 🍻🥳

[dontrimp]

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

[InspiringLeadersManish]

Thank You so much, was missing the curly brackets.

[jaymanuel]

Deyymm. You saved me bro. Thanks for this

[deborahv.]

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

[jaguarprovo]

U son of a gun! U helped me tremendously

[blackrain]

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!

[aslanbarisim]

Thanks for your very helpful video ...

[yazminghale]

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

[cymrirc]

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