Hello Ajay I am very comfortable with sumifs and countifs, thanks for the videos. I m dealing with large data set at work. I want to write a code using sumifs in a clean sheet referencing to a different workbook saved in another folder. Which videos do you recommend
If we know basics doesn't matter if function is being used within sheet or across sheets or From other wotbooks. Just go and select table wherever it is. Excel will automatically create the sheet name or workbook name prefixed before tables..
Good day I need to sum a dynamic. I am using a code below and it is not working Cells(row, 2).Value = WorksheetFunction.Sum(Sheets("All Claims").Cells(Sheets("All Claims").Rows.Count, 22).End(xlUp).row My data is in sheet "All claim" column 22. Please assist
Please use range... worksheet.function.sum(sheets ("all claims").range ("f2:F4")). Ofcourse you can range dynamic by using variable to find last row... Hope that helps.. Watch my video on range introduction... playlist name is Excel Vba introduction
![Felix "Unfair" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/Oswujxm2Ag0/mqdefault.jpg)
Great✌️👌
Thank you very much. I have already looped the data that I was working on at work before even watching the next video. You are a star
And you are my star!
Hello sir wonderful thank u.. very nice
You are welcome..
Thanks for this video, it was really helpful in my job, keep uploading such great videos,
Thank you Prakash.
Sir, how to use countif in vba for counting d interior cell color?
Hello Ajay
I am very comfortable with sumifs and countifs, thanks for the videos. I m dealing with large data set at work. I want to write a code using sumifs in a clean sheet referencing to a different workbook saved in another folder. Which videos do you recommend
If we know basics doesn't matter if function is being used within sheet or across sheets or From other wotbooks. Just go and select table wherever it is. Excel will automatically create the sheet name or workbook name prefixed before tables..
I meant a VBA code that uses sumifs referencing anather workbook
Please check Excel Vba function Playlist
Good day
I need to sum a dynamic. I am using a code below and it is not working
Cells(row, 2).Value = WorksheetFunction.Sum(Sheets("All Claims").Cells(Sheets("All Claims").Rows.Count, 22).End(xlUp).row
My data is in sheet "All claim" column 22. Please assist
Please use range... worksheet.function.sum(sheets ("all claims").range ("f2:F4")). Ofcourse you can range dynamic by using variable to find last row... Hope that helps..
Watch my video on range introduction... playlist name is Excel Vba introduction
Thanks a lot> I cant stop jumping. My code is running perfect
Cells(row, 2).Value = WorksheetFunction.SumIfs(Sheets("Sheet2").Range("V2:V" & LastRow), Sheets("Sheet2").Range("J2:J" & LastRow), Sheets("Sheet1").Cells(row, 1), Sheets("Sheet2").Range("A2:A" & LastRow), Sheets("Sheet1").Range("J2"))
wow wow...awesome..