Excel index sum (basic vba question)

[Youseepooo]

Hello
So im new to VBA, and for one of my WB's i want to sum a certain column up ( Column until a certain row which depends on a range on a different sheet.

For example. If i have payments from day 1 to day 20 in column "B" on sheet "1340 $" and on my "Summary" Sheet i have the days 18,19,20 with only their daily payments. How can i go to a specific sheet and sum a column up until a range depended on a cell value in a different sheet.
I would like someone to help me understand this because i am very eager to learn VBA.


If someone still doesnt understand me let me know and i will provide a sample table with a clear informative question.

Thanks
YM, CIVIL ENGINEER

 

[Jeffrey Mahoney]

Use SUMIFS(). You don't need VBA. If you have Col B as the day and Col A as the amount...
=SUMIFS('1340 $'!$A2:$A100,'1340 $'!$B2:$B100,Sheet1!A2)
* Where Sheet1!A2 contains 18
* Would sum all the amounts where column b has day 18

 

[Youseepooo]

Yea sorry for late response , I did use sumif() not ifs but I wanted to see if there was an easier way to do it with VBA