thanks, great use of a wildcard for future use. Paul
@ianl10523 ай бұрын
Another great video. Thanks.
@jerrydellasala76435 ай бұрын
Glad you showed the wildcard option. Rather than having to do two sumifs for Open + Pending, that could have been =SUMIFS(C12:C20,D12:D20,"*pen*") Note that with text it's NOT case sensitive! Also, using array notation, the formula =SUMIFS(C12:C20,D12:D20,{"Open","Pending"}) returns those two values, but in two cells in a row (changing the comma between Open and Pending would return the values in a column. While it's not elegant, the formula =SUM(SUMIFS(C12:C20,D12:D20,{"Open","Pending"})) also works. I really like these short videos you do, and have gone through a lot of your others. Would love to see more longer videos WITH SAMPLE FILE(S).
@jeffolefson94155 ай бұрын
Interesting but frankly using two sumif or two sumifs seems simplier. But thanks for showing. I enjoyed trying it out.
@jeffolefson94155 ай бұрын
You could also have used sum if for both of these two conditions. But you make a good point. Sumifs is universal it can do sumif type conditions and multiple conditional or sumifs.
@HARwinsOUTagain5 ай бұрын
ExcelU catchphrase: “So what are we supposed to do…do it manually?” “No!!!” 😎
@yankoyankov27525 ай бұрын
Thank you so muuch . I was looking for exactly that and your video made it to my feed . Have a wonderful day filed with joy and excitement .
@kkfinancialadvisorycharter63565 ай бұрын
Good job
@micheltremblay81845 ай бұрын
It would be possible with this for OR SUMIFS =SUM(SUMIFS(C12:C20,D12:D20,{"Open","Pending"}))
@jeffolefson94155 ай бұрын
Yep not sure that is an advantage but yes it would work. You could also use sumif in this example as well.
@johnboffin4765 ай бұрын
Hello Sir, I am building a spreadsheet with 7 columns and 1200 rows. Column A is just a reference column, B is dates column which are fine, column C is with Validation drop down codes list, column D is details with drop down, tested and working all down to 1200 rows. Column E is payments F is Income and G is balance (Balance column work as it should) now I need your input in column E and F, If I select from column C for Income code it should only allow me the income column and if selected payment from C it should allow me to enter in payments column. In income column I have 5 source of income and payments I have about 44 or it may grow prior (My code list and details list grows as it should). I need help using validation (Custom) in these two columns E & F, so that the entry don't get switched between two. Thanks a lot if you could help.. (I use Excel 2000)
@mohamedmeshref5 ай бұрын
Why did not you put an excel sheet to try your ideas on it?