Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by xcapes

  1. xcapes

    Total SUM of column A if check box in column B is checked (HELP)

    That worked great! Thanks! Talk about saving me a lot of time!
  2. xcapes

    Total SUM of column A if check box in column B is checked (HELP)

    Thanks! I'll do a search on the help for linking a cell to a checkbox and then use the SUMIF... Thanks for all the help!
  3. xcapes

    Total SUM of column A if check box in column B is checked (HELP)

    Wow! Thanks for all the quick replies. antoineh, If i can do it without using VBA then all the better... The problem I encountered when trying to use a function like IF or SUMIF was that I was not getting a value for the checkbox when checked (maybe i'm missing how to do that...) SkipVought...
  4. xcapes

    Total SUM of column A if check box in column B is checked (HELP)

    I want to be able to add all the prices of each row item if the item is checked off... so for example: A B C item1 $5 checked (assume a checkbox) item2 $3 not checked item3 $4 cheked total $9 I know this can be done but being as I've never written VBA for excel im a little unsure...
  5. xcapes

    Bizarre problem -- lose connection randomly to/from Windows Server 200

    Well, the problem was fixed by doing two things but I am not sure that they were the culprits... 1) I reinstalled Windows 2003 Server but this time I did not use the Enterprise edition... 2) I only installed the roles I knew I needed. I think that the print and file server roles may have been...
  6. xcapes

    Bizarre problem -- lose connection randomly to/from Windows Server 200

    Had not tried setting to half duplex... I will give these a try and see what happens... it may be several days... but if more than 6 days go by then we may have a winner. Thanks for all the responses!
  7. xcapes

    Bizarre problem -- lose connection randomly to/from Windows Server 200

    Thanks for the response. Yeah I've tried both thinking the same, but no luck. Sometimes the connection stays on for 5 or 6 days and others it will go out in a matter of seconds after reboot... I'm very close to reinstalling W2K to rule out HW failure...
  8. xcapes

    Bizarre problem -- lose connection randomly to/from Windows Server 200

    I have been running Windows 2003 Server for my home network for a couple of months now. Since install I have had a strange problem where I will lose connection to/from my server. The problem isn't fixed until I reboot the machine. I am using the server as my PDC, AD, DNS, WEB, and file server...

Part and Inventory Search

Back
Top