View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Kurt Kurt is offline
external usenet poster
 
Posts: 47
Default 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