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 Chriss Miller 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 akira04

  1. akira04

    Excel: excluding selections in adding totals

    Skip- you are awesome!
  2. akira04

    Excel: excluding selections in adding totals

    I have a spreadsheet that totals scores by person: Jeff 1200 Jake 1245 Emily 2005 Gordon 2154 Thomas 1211 James 955 Roger 1055 Les 1506 Jon 1425 I would like a formula that will add up the scores excluding 3 some...
  3. akira04

    add dollar amounts between two ranges

    I tried SUMIF(see my first post) but I couldn't get it to go- Lets say I have a table with unsorted dollar amounts like so: $12542 $50000 $1254 $5122 $4521 $2541 $1525 I would like a formula that will look at this range and add the total of any dollar amounts between $1000 and $5000- HB
  4. akira04

    add dollar amounts between two ranges

    my apologies if I I didn't explain clearly. what I really need is a simple formula that will add numbers within a given range for instance- sum(range between >=100 and <=250) etc. I can seem to find this solution anywhere.
  5. akira04

    add dollar amounts between two ranges

    I have a database in which I would like to calculate dollar amounts between particular dollar ranges, So far I am using the following formula to count how many entries are at within each range, =SUMPRODUCT(('all workinglist'!G$2:G$2087>=500000)*('all workinglist'!G$2:G$2087<=749999)) Doller...
  6. akira04

    Want to save e-mails from outlook

    I'm switching data from one pc to another. I want to save the e-mails in my Outlook accounts but I don't know where they are stored. Please advise.
  7. akira04

    Want to print odd/even page numbers in MS Word

    I want to print a multi-page document for double sided printing. So I can print 1 document with even pages, turn it over, and print the other side with odd pages. Does anyone know how to configure the documents to only number by odd or even?
  8. akira04

    Want to repair XP Pro with XP Home upgrade

    yeah, I may have to do this if it is not possible to repair XP pro with XP home- Anyone know if this is possible?
  9. akira04

    Want to repair XP Pro with XP Home upgrade

    My system has been hosed for the past couple of months- It crashes suddenly when I defrag, when I run an AD-aware scan, when I run a Norton virus scan, sometimes when I open large files, and now it is just doing random crashes. I've been trying to find any solution to avoid having to reinstall...

Part and Inventory Search

Back
Top