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

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

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

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

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

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

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

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

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

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

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

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

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