I need help with a satement that will verify the date in one row(sheet1.A3) and a second value(sheet1.c3) are equal to set values. If they are both equal i need to start a running total. then display that total on a diffrent sheet.

I understand the basics of programing, just not the language that excel uses. I was going to have the user enter the total number of itterations.

I need to know how to increase the row using the loop variable. and I need to know how to pass data from workbook, to VBA, and back.

So in excel say sheet1.A1 is the total number of times to do the loop.
stuff in { } is what i need help with.
the IF is writen in what Excel uses for an if statement which i believe is not what the VBA will use.

num = 0
For loopx = 3 to Sheet1.A1
If((AND(Sheet1!A3{this needs to increase with the count of loopx} = dateiamlookingfor, Sheet1!C3{this needs to increase with the count of loopx} = valueiamlookingfor)),num = num + E3{this needs to increase with the count of loopx}
next loopx
{Print num to a cell on sheet2}

I know its alot to ask, my brain is just dead, and i do not know much about excel...yet

Thanks