Excel SUM with Conditions

[@meluvu1tym190]

This guy is great. Bought his excel course - very detailed and very easy to follow.

[@OfficeNewb]

Thank you

[@gillianmcnosehair9097]

Sumproduct always causes issues. Thank you for the great vid, Kyle.

[@gooddude9211]

Brilliantly done sir. Loved it and learnt sumifs. Thanks a lot for the detailed video lesson.

[@OfficeNewb]

Glad you liked it!

[@mdishtiyaq3553]

I have question. Do you have any videos related to error in excel, if yes then may I know how to get values in place of error?

[@OfficeNewb]

No video on this yet!

[@Fahim_Khan_]

Great video sir. But I have one doubt- why do you give absolute reference in that formula of sumif?

[@OfficeNewb]

Glad you enjoyed the Video! We use absolute reference if we want to copy the formula to other cells and don't want the cells to change in the formula

[@kkeshavmishra]

nice tutorials. which software you use for anotation.

[@OfficeNewb]

Are you asking about the Red marks? it is a free app called ZOOMIT. You can find the download from Microsoft below. docs.microsoft.com/en-us/sysinternals/downloads/zoomit

[@mohamedidris7435]

May I know why you are using absolute reference ?why can't you simply select the range?why because you used dollar function in your udemy course to do not change division value in percentage value,,,can you explainwhy you are using here

[@OfficeNewb]

We only use absolute reference when we want to copy a formula to anther cell so a cell or row or column does not change. Cell $C$2, Row C$2 or Column $C2