2 Resources for

ipctrain

Sponsored White Papers, Webcasts, and Downloads

Using 'AND' Logic in a 'SUMIF' Statement: In EXCEL 2003, how can I incorporate 'AND' logic in a 'SUMIF' statement? If not, what other function can I use to sum a column of cells given TWO conditions. This is what I have and it does not work: =SUMIF(Salary!G9:G62,62008+AND(Salary!J9:J62,40102),Salary!Y9:Y62). I'm testing G9:G62 for value "62008" AND J9:J62 for...; Tags: Sumif, Salary!Y9:Y62, IPCTrain, software, Salary!J9:J62,40102; Q&A 2006-03-09
Bios: How do I reset the Bios battery on a PC?Depending on the model, it is usually accomplished by removing AC power and then setting a jumper or removing the battery backup.Keep your motherboard manual handy. Locate the battery on the motherboard (looks similar to a digital watch battery, as big...; Tags: battery, BIOS, hardware, IPCTrain, jumper, socket; Q&A 2005-08-30

Troubleshooting Patch Cables Power Checklist: Call them what you want: patch, Ethernet, category 5, or even cat 5e cables. Regardless of the moniker, Ethernet patch cables perform the bulk of the ...; Buy Now

TechRepublic FastAnswer: Assigning Keywords To Files - PDF: XP's Search feature can help you find data files on a workstation quickly, but you can make it even faster. This FastAnswer shows how to add keywords to file to help Search find them faster.; Buy Now