Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
"CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION | Excel Discussion (Misc queries) | |||
Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! | Excel Discussion (Misc queries) | |||
convert "15000" to "Fifteen thousand" in excel cell? | Excel Worksheet Functions | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) |