cell reflect an amount when "C" is typed in, then sum last cell

3/30/2009 1 2 3 4 5 - 31 row five
service charge row six

Mowing $45.00 [ ] [X] [ ] [ ] [ ] ---[ ] [$45.00] row eight

This is basic what I have, I want to be able to select any of the days of
the month in the aray and have that amount to show at the end when I select
that date with an X. In row five the only thing that changes is the
date...changes with the current date. In row eight the only thing I want to
happen is to give a pre-set number at the end and if I select several more
dates I need them to sum. Right now it sums but I can not get it to do the
??circle thing??? and read it, like a loop only once. VERY VERY new to this
guys...sorry and thank you for any help.. Kurt

--
Life is a beach...then you forget your suit...Deal with it and go skinny
dippin

Apply this formula in the sum cell. I assume the values are from Column C to
Column AG .

=SUMIF(C8:AG8,"=X",C6:AG6)

If this post helps click Yes
---------------
Jacob Skaria


"Kurt" wrote:

3/30/2009 1 2 3 4 5 - 31 row five
service charge row six

Mowing $45.00 [ ] [X] [ ] [ ] [ ] ---[ ] [$45.00] row eight

This is basic what I have, I want to be able to select any of the days of
the month in the aray and have that amount to show at the end when I select
that date with an X. In row five the only thing that changes is the
date...changes with the current date. In row eight the only thing I want to
happen is to give a pre-set number at the end and if I select several more
dates I need them to sum. Right now it sums but I can not get it to do the
??circle thing??? and read it, like a loop only once. VERY VERY new to this
guys...sorry and thank you for any help.. Kurt

--
Life is a beach...then you forget your suit...Deal with it and go skinny
dippin

Thank you Jacob, but it didn't work... Row 5 C-AG is only a ref for the month
day/ date. the =TODAY() in cell B5 is only for the year for reference. The
problem is that I need row C8 thru AG8 to give me the value of $45.00 in cell
AH8 when I select a cell referencing from above C5 thru AG5. What has to
happen is I reference a date from above and select the cell below it. It then
has to give the result of $45.00 or a multple of them in AH8. And sorry the
"C" referenced in the Subject is really "X", but you saw that :-} I don't
know how to make the reference to a row for a row and send its total to a
cell...make sence?...I hope so... looks confussing to me...hehe Thank you
--
Life is a beach...then you forget your suit...Deal with it and go skinny
dippin


"Jacob Skaria" wrote:

Apply this formula in the sum cell. I assume the values are from Column C to
Column AG .

=SUMIF(C8:AG8,"=X",C6:AG6)

If this post helps click Yes
---------------
Jacob Skaria


"Kurt" wrote:

3/30/2009 1 2 3 4 5 - 31 row five
service charge row six

Mowing $45.00 [ ] [X] [ ] [ ] [ ] ---[ ] [$45.00] row eight

This is basic what I have, I want to be able to select any of the days of
the month in the aray and have that amount to show at the end when I select
that date with an X. In row five the only thing that changes is the
date...changes with the current date. In row eight the only thing I want to
happen is to give a pre-set number at the end and if I select several more
dates I need them to sum. Right now it sums but I can not get it to do the
??circle thing??? and read it, like a loop only once. VERY VERY new to this
guys...sorry and thank you for any help.. Kurt

--
Life is a beach...then you forget your suit...Deal with it and go skinny
dippin

Oh My Gosh... I got it... I used this and it works oh so well...thank you for
making me think a bit more... =COUNTIF(C8:AG8,"=X")*(45). I didn't have to
reference the row 5. All I had to do was make it count the entrys and
multiply by the amount...this case $45.00... TYVM for the reply.
--
Life is a beach...then you forget your suit...Deal with it and go skinny
dippin


"Kurt" wrote:

3/30/2009 1 2 3 4 5 - 31 row five
service charge row six

Mowing $45.00 [ ] [X] [ ] [ ] [ ] ---[ ] [$45.00] row eight

This is basic what I have, I want to be able to select any of the days of
the month in the aray and have that amount to show at the end when I select
that date with an X. In row five the only thing that changes is the
date...changes with the current date. In row eight the only thing I want to
happen is to give a pre-set number at the end and if I select several more
dates I need them to sum. Right now it sums but I can not get it to do the
??circle thing??? and read it, like a loop only once. VERY VERY new to this
guys...sorry and thank you for any help.. Kurt

--
Life is a beach...then you forget your suit...Deal with it and go skinny
dippin

Am i understanding this differently.

1 2 3 4 5 ... 31 (row five)
(row six)
X X X X X ... X Total (row eight)

The below formula in AH8 will return the sum of values in C6 to AG6 if X is
marked in row eight C8 to AG8.

=SUMIF(C8:AG8,"=X",C6:AG6)

If this post helps click Yes
---------------
Jacob Skaria


"Kurt" wrote:

Thank you Jacob, but it didn't work... Row 5 C-AG is only a ref for the month
day/ date. the =TODAY() in cell B5 is only for the year for reference. The
problem is that I need row C8 thru AG8 to give me the value of $45.00 in cell
AH8 when I select a cell referencing from above C5 thru AG5. What has to
happen is I reference a date from above and select the cell below it. It then
has to give the result of $45.00 or a multple of them in AH8. And sorry the
"C" referenced in the Subject is really "X", but you saw that :-} I don't
know how to make the reference to a row for a row and send its total to a
cell...make sence?...I hope so... looks confussing to me...hehe Thank you
--
Life is a beach...then you forget your suit...Deal with it and go skinny
dippin


"Jacob Skaria" wrote:

Apply this formula in the sum cell. I assume the values are from Column C to
Column AG .

=SUMIF(C8:AG8,"=X",C6:AG6)

If this post helps click Yes
---------------
Jacob Skaria


"Kurt" wrote:

3/30/2009 1 2 3 4 5 - 31 row five
service charge row six

Mowing $45.00 [ ] [X] [ ] [ ] [ ] ---[ ] [$45.00] row eight

This is basic what I have, I want to be able to select any of the days of
the month in the aray and have that amount to show at the end when I select
that date with an X. In row five the only thing that changes is the
date...changes with the current date. In row eight the only thing I want to
happen is to give a pre-set number at the end and if I select several more
dates I need them to sum. Right now it sums but I can not get it to do the
??circle thing??? and read it, like a loop only once. VERY VERY new to this
guys...sorry and thank you for any help.. Kurt

--
Life is a beach...then you forget your suit...Deal with it and go skinny
dippin

To better that =COUNTIF(C8:AG8,"=X")*(B8)

If this post helps click Yes
---------------
Jacob Skaria


"Kurt" wrote:

Oh My Gosh... I got it... I used this and it works oh so well...thank you for
making me think a bit more... =COUNTIF(C8:AG8,"=X")*(45). I didn't have to
reference the row 5. All I had to do was make it count the entrys and
multiply by the amount...this case $45.00... TYVM for the reply.
--
Life is a beach...then you forget your suit...Deal with it and go skinny
dippin


"Kurt" wrote:

3/30/2009 1 2 3 4 5 - 31 row five
service charge row six

Mowing $45.00 [ ] [X] [ ] [ ] [ ] ---[ ] [$45.00] row eight

This is basic what I have, I want to be able to select any of the days of
the month in the aray and have that amount to show at the end when I select
that date with an X. In row five the only thing that changes is the
date...changes with the current date. In row eight the only thing I want to
happen is to give a pre-set number at the end and if I select several more
dates I need them to sum. Right now it sums but I can not get it to do the
??circle thing??? and read it, like a loop only once. VERY VERY new to this
guys...sorry and thank you for any help.. Kurt

--
Life is a beach...then you forget your suit...Deal with it and go skinny
dippin

Oh Wow Cool... (B8)... yep tyvm dude.. Be cool and I am gonna mark yes for
help..
--
Life is a beach...then you forget your suit...Deal with it and go skinny
dippin


"Jacob Skaria" wrote:

To better that =COUNTIF(C8:AG8,"=X")*(B8)

If this post helps click Yes
---------------
Jacob Skaria


"Kurt" wrote:

Oh My Gosh... I got it... I used this and it works oh so well...thank you for
making me think a bit more... =COUNTIF(C8:AG8,"=X")*(45). I didn't have to
reference the row 5. All I had to do was make it count the entrys and
multiply by the amount...this case $45.00... TYVM for the reply.
--
Life is a beach...then you forget your suit...Deal with it and go skinny
dippin


"Kurt" wrote:

3/30/2009 1 2 3 4 5 - 31 row five
service charge row six

Mowing $45.00 [ ] [X] [ ] [ ] [ ] ---[ ] [$45.00] row eight

This is basic what I have, I want to be able to select any of the days of
the month in the aray and have that amount to show at the end when I select
that date with an X. In row five the only thing that changes is the
date...changes with the current date. In row eight the only thing I want to
happen is to give a pre-set number at the end and if I select several more
dates I need them to sum. Right now it sums but I can not get it to do the
??circle thing??? and read it, like a loop only once. VERY VERY new to this
guys...sorry and thank you for any help.. Kurt

--
Life is a beach...then you forget your suit...Deal with it and go skinny
dippin