kixelsid,

A couple questions first.

1. Will the values you are looking for/adding to running total always
be in the same row? For example will you be comparing A3 = date, C3 =
value, and E3 added to running total; then A4, C4, E4; then A5, C5,
E5...etc.

2. Will you be looking for the first occurence of (Ax = date) AND (Cx
= value) and starting your running total from there and going until
the end, OR will your running total only add the value in E at each
occurence of (Ax = date) AND (Cx = value)? How you have your question
written, it appears that it will only add to the running total at each
occurence of (Ax = date) AND (Cx = value).

Conan



"kixelsid"
wrote in message
...

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


--
kixelsid
------------------------------------------------------------------------
kixelsid's Profile:
http://www.excelforum.com/member.php...o&userid=31901
View this thread:
http://www.excelforum.com/showthread...hreadid=516301