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
|