The Excel SUMIFS Function
video description
P.S. I am trying to figure this out for a real application. I am trying to sum values of different trading accounts by account type. I am not able to list a single cell with the account type in quotes. For example... -Trading- or -Roth IRA-
Date: 2022-04-08
Related videos
Comments and reviews: 7
Performance
How do you overcome a problem when both or more criteria ranges are actually in 1 column , say if you use SUMIFS and try to add up the cost of DVD and BLUE RAY in a single cell it wont work??? Anyone has any ideas????
reply
How do you overcome a problem when both or more criteria ranges are actually in 1 column , say if you use SUMIFS and try to add up the cost of DVD and BLUE RAY in a single cell it wont work??? Anyone has any ideas????
reply
Ivy
Hi, thanks for the video, it's useful! However, what if the -criteria range- is to choose the integral number out of a set of data containing both integral and decimal point of number? I'm having a headache in this ;/
reply
Hi, thanks for the video, it's useful! However, what if the -criteria range- is to choose the integral number out of a set of data containing both integral and decimal point of number? I'm having a headache in this ;/
reply
Fraser's
Is is possible, to sumifs with a negative criteria... So, -is not equal to mystery- as in everything else but.. ? also, thank you , you're video was very helpful.
reply
Is is possible, to sumifs with a negative criteria... So, -is not equal to mystery- as in everything else but.. ? also, thank you , you're video was very helpful.
reply
eliphs11
Thank you for this and your other tutorial videos! Using what I learn to create a dynamic budget tracker and your videos have proven to be indispensable.
reply
Thank you for this and your other tutorial videos! Using what I learn to create a dynamic budget tracker and your videos have proven to be indispensable.
reply
education
This could be easily done through pviot table then why should go for sumif? could you please assist and clear my doubts. Thanks in advance
reply
This could be easily done through pviot table then why should go for sumif? could you please assist and clear my doubts. Thanks in advance
reply
Jay
I really like how you start off by pointing out what you could do. Those are the things I would've tried or have been trying. Brilliant video!
reply
I really like how you start off by pointing out what you could do. Those are the things I would've tried or have been trying. Brilliant video!
reply
Erin
Thank you thank you for this video! I could not find out what was wrong with my formula and watching this video once fixed it.
reply
Thank you thank you for this video! I could not find out what was wrong with my formula and watching this video once fixed it.
reply
Add a review, comment
Other channel videos
