-
WSboat
AskWoody Loungerhi all, hi Steve, hi anyone, i got the Excel list of Date, Net P/L and Total Turnround. as usual, the Date and Net P/L is done but total turnround left out. just Total Turnround sit besides Net P/L. can someone tell me which cell to place the Total Turnround item to get that? THANKS A LOT.
-
WSboat
AskWoody Loungerhi Pieterse, sorry, maybe i do not understand your instruction on editing my formula. now, i hit F2 at G2 to provoke the formula on G2 out and i press left arrow key to edit my formula, just like from =SUM((A2),(D2),(F2)) to =SUM((A2),(B2),(F2)) and lastly press Ctrl+Shift+Down Arrow to complete the formula copies to G6000. about named formula to change =SUM((A2),(D2),(F2)) to =TEST, and =TEST appears in G2 until G6000, and when i need to change =SUM((A2),(D2),(F2)) to =SUM((A2),(B2),(F2)), do i have to go Insert-Name-Define- select TEST and edit in the Refers to: column from =SUM((A2),(D2),(F2)) to =SUM((A2),(B2),(F2))? if that is the case, i will stick to my original way. Thanks again.
-
WSboat
AskWoody Loungerhi Pieterse, sorry, maybe i do not understand your instruction on editing my formula. now, i hit F2 at G2 to provoke the formula on G2 out and i press left arrow key to edit my formula, just like from =SUM((A2),(D2),(F2)) to =SUM((A2),(B2),(F2)) and lastly press Ctrl+Shift+Down Arrow to complete the formula copies to G6000. about named formula to change =SUM((A2),(D2),(F2)) to =TEST, and =TEST appears in G2 until G6000, and when i need to change =SUM((A2),(D2),(F2)) to =SUM((A2),(B2),(F2)), do i have to go Insert-Name-Define- select TEST and edit in the Refers to: column from =SUM((A2),(D2),(F2)) to =SUM((A2),(B2),(F2))? if that is the case, i will stick to my original way. Thanks again.
-
WSboat
AskWoody LoungerHi Pieterse, i think i understand the named formula in that way, but, the first cell formula requires changes in its input, let say in G2, a formula goes =SUM((A2),(D2),(F2)) and i copy the first cell formula to G6000, 5 seconds later, i change the fomula on G2 to =SUM((A2),(B2),(F2)) and copy down to G6000, and 5 seconds later, i change the G2 formula again to do some kind of testing. with this, i think this named formula cannot fit this requirement, can it? either there is a better way to reduce this kind of formula memory or i just fix to this formula and copy to G6000, as original way? THANKS for any help.
-
WSboat
AskWoody LoungerHi Pieterse, i think i understand the named formula in that way, but, the first cell formula requires changes in its input, let say in G2, a formula goes =SUM((A2),(D2),(F2)) and i copy the first cell formula to G6000, 5 seconds later, i change the fomula on G2 to =SUM((A2),(B2),(F2)) and copy down to G6000, and 5 seconds later, i change the G2 formula again to do some kind of testing. with this, i think this named formula cannot fit this requirement, can it? either there is a better way to reduce this kind of formula memory or i just fix to this formula and copy to G6000, as original way? THANKS for any help.
-
WSboat
AskWoody Loungerhi Steve, thanks a lot for your advice. about the ‘named formula’, let say i have a formula that inputs are still variable, and the formula need to be copied down, far down to row6000, how am i going to do the ‘named formula’? thanks again.
-
WSboat
AskWoody Loungerhi Steve, thanks a lot for your advice. about the ‘named formula’, let say i have a formula that inputs are still variable, and the formula need to be copied down, far down to row6000, how am i going to do the ‘named formula’? thanks again.
-
WSboat
AskWoody Loungerhi John, hi jscher2000, i notice my cd-rw written one is 1X-12X and another is 4X-10X Compatible that is why i think the speed defaulted at 12X might be more than the cd-rw expected. somehow, i don’t know how to interpret the both cd-rw speed requirement i mean where should the speed level be for both cd-rw, i have no clue. THANKS.
-
WSboat
AskWoody Loungerhi John, hi jscher2000, i notice my cd-rw written one is 1X-12X and another is 4X-10X Compatible that is why i think the speed defaulted at 12X might be more than the cd-rw expected. somehow, i don’t know how to interpret the both cd-rw speed requirement i mean where should the speed level be for both cd-rw, i have no clue. THANKS.
-
WSboat
AskWoody Loungerhi StuartR, i restart the pc just after the completion of Windows update installation the last i did after i had a good working pc. somehow, i had the pc reformated by pc technician for about USD 2.6 and here in Malaysia it is RM10. i then install my softwares home to save the cost. if not, the reformatting and softwares installation would charge around USD 13 and here in Malaysian Ringgit is RM50. anyway, money is another matter. i want to learn how to reformat the pc? reformat the pc will makes the pc empty, maybe is it called ‘clean’? can you give me the steps to reformat pc or some links to it so that i can have a start? THANK YOU StuartR.
-
WSboat
AskWoody Loungerhi StuartR, i restart the pc just after the completion of Windows update installation the last i did after i had a good working pc. somehow, i had the pc reformated by pc technician for about USD 2.6 and here in Malaysia it is RM10. i then install my softwares home to save the cost. if not, the reformatting and softwares installation would charge around USD 13 and here in Malaysian Ringgit is RM50. anyway, money is another matter. i want to learn how to reformat the pc? reformat the pc will makes the pc empty, maybe is it called ‘clean’? can you give me the steps to reformat pc or some links to it so that i can have a start? THANK YOU StuartR.
-
WSboat
AskWoody Loungerhi StuartR, the pc runs like this Start- Startup Recovery Menu- Windows Logo- and a blink of blue screen with some unclear words because the blue screen blinks very fast and then the pc runs to Start- Startup Recovery Menu- Windows Logo- a blink of blue screen with some unclear words- back to Start again and so on the cycle of the pc runs. I tried with Start in Safe Mode, Safe Mode in Networking, Safe Mode with Command Prompt, Last Known good configuration and Starts Window Normally and the pc still runs the cycle above. Any helps clue ? THANKS.
-
WSboat
AskWoody Loungerhi StuartR, the pc runs like this Start- Startup Recovery Menu- Windows Logo- and a blink of blue screen with some unclear words because the blue screen blinks very fast and then the pc runs to Start- Startup Recovery Menu- Windows Logo- a blink of blue screen with some unclear words- back to Start again and so on the cycle of the pc runs. I tried with Start in Safe Mode, Safe Mode in Networking, Safe Mode with Command Prompt, Last Known good configuration and Starts Window Normally and the pc still runs the cycle above. Any helps clue ? THANKS.
-
WSboat
AskWoody LoungerHi Steve, THANK YOU SO MUCH for all your formulas. Your formula still not get when there is if in row11 all are S you cannot get a S in Target, but I learned a bit about your formula and get it correct: in AK10, the formula is =IF(COUNTIF(A10:U10,”B”)=21,”B”,IF(COUNTIF(A10:U10,”S”)=21,”S”,AK9)) and in AL10 the formula is =IF(AK10=AK9,0,AK10). That
-
WSboat
AskWoody LoungerHi Steve, THANK YOU SO MUCH for all your formulas. Your formula still not get when there is if in row11 all are S you cannot get a S in Target, but I learned a bit about your formula and get it correct: in AK10, the formula is =IF(COUNTIF(A10:U10,”B”)=21,”B”,IF(COUNTIF(A10:U10,”S”)=21,”S”,AK9)) and in AL10 the formula is =IF(AK10=AK9,0,AK10). That
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
CISA warns of hackers targeting critical oil infrastructure
by
Nibbled To Death By Ducks
8 hours, 24 minutes ago -
AI slop
by
Susan Bradley
7 hours, 35 minutes ago -
Chrome : Using AI with Enhanced Protection mode
by
Alex5723
9 hours, 41 minutes ago -
Two blank icons
by
CR2
16 hours, 10 minutes ago -
Documents, Pictures, Desktop on OneDrive in Windows 11
by
ThePhoenix
18 hours, 35 minutes ago -
End of 10
by
Alex5723
21 hours, 15 minutes ago -
End Of 10 : Move to Linux
by
Alex5723
21 hours, 44 minutes ago -
Single account cannot access printer’s automatic duplex functionality
by
Bruce
18 hours, 13 minutes ago -
test post
by
gtd12345
1 day, 3 hours ago -
Privacy and the Real ID
by
Susan Bradley
17 hours, 23 minutes ago -
MS-DEFCON 2: Deferring that upgrade
by
Susan Bradley
9 hours, 30 minutes ago -
Cant log on to oldergeeks.Com
by
WSJonharnew
1 day, 7 hours ago -
Upgrading from Win 10
by
WSjcgc50
8 hours, 59 minutes ago -
USB webcam / microphone missing after KB5050009 update
by
WSlloydkuhnle
1 hour, 12 minutes ago -
TeleMessage, a modified Signal clone used by US government has been hacked
by
Alex5723
1 day, 23 hours ago -
The story of Windows Longhorn
by
Cybertooth
1 day, 11 hours ago -
Red x next to folder on OneDrive iPadOS
by
dmt_3904
2 days, 1 hour ago -
Are manuals extinct?
by
Susan Bradley
12 hours, 43 minutes ago -
Canonical ditching Sudo for Rust Sudo -rs starting with Ubuntu
by
Alex5723
2 days, 10 hours ago -
Network Issue
by
Casey H
1 day, 21 hours ago -
Fedora Linux is now an official WSL distro
by
Alex5723
2 days, 22 hours ago -
May 2025 Office non-Security updates
by
PKCano
2 days, 22 hours ago -
Windows 10 filehistory including onedrive folder
by
Steve Bondy
3 days ago -
pages print on restart (Win 11 23H2)
by
cyraxote
2 days, 1 hour ago -
Windows 11 Insider Preview build 26200.5581 released to DEV
by
joep517
3 days, 2 hours ago -
Windows 11 Insider Preview build 26120.3950 (24H2) released to BETA
by
joep517
3 days, 2 hours ago -
Proton to drop prices after ruling against “Apple tax”
by
Cybertooth
3 days, 10 hours ago -
24H2 Installer – don’t see Option for non destructive install
by
JP
2 hours, 13 minutes ago -
Asking Again here (New User and Fast change only backups)
by
thymej
3 days, 21 hours ago -
How much I spent on the Mac mini
by
Will Fastie
1 day, 5 hours ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.