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" <kixelsid.23r03a_1140808801.2831@excelforum-nospam.com>
wrote in message
news:kixelsid.23r03a_1140808801.2831@excelforum-nospam.com...
>
> 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
>