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 dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ptweb
  • Content: Threads
  • Order by date
  1. ptweb

    ADDING AN AND

    Hi =SUMIF(G2:G36,0,E2:E36) I would like to add a AND condition to this sum so that H2:H36 also equal 0... bit confused
  2. ptweb

    running Apache::ASP

    Hello, I've been the the page below and think I have installed everything, how do start the ASP? APACHE is working and I've done all the cpan stuff.. http://www.apache-asp.org/install.html#Download%20and86dfc858
  3. ptweb

    Apache

    Does anyone know is apache supports Active server pages?
  4. ptweb

    IIS on XP Home

    I Followed this tutorial to enable me to install iis, I get the view of iis but wont let me tick it/. tut = http://adamv.com/dev/articles/iis-on-xp-home iis=iis2.dll,OcEntry,iis2.inf,,7
  5. ptweb

    IIS

    i followed the above steps to install iis in my xp home edition.Now i can see aplication server in the add remove box,but i am not able to select it,above all i can see the details of it but cant select any of option under application
  6. ptweb

    IIS on winxp home edition

    IIS on winxp home Edition? I recently made adjustments to my home edition software so I could use IIS web server components, this is posted all over the web how to do this but not my problem, I did everything required and IIS is visible or selectable but the checkbox is not active, it wont...
  7. ptweb

    FORMULA PROBLEM

    Hello, I have this forumla =SUMIF('EXPENSES SALES'!E61:E574,B15,'EXPENSES SALES'!H61:H574) Instead of gathering totals in this region H61:H574 I would like also to get the total from the row id entered into cell B15 ... to try and make in clear, get some totals of all rows and have the value...
  8. ptweb

    excel prb

    Hi I have this prob, I need to the "AND format for excel on the first IF statement, not sure what it is.. if not NO AND another cell not yes... ..I hope my formula helps =IF(F201<>"no", SUM((I201)*7/47),IF(J201>0,IF(LEN(J201)>0,IF(G201="yes",SUM((I201)*7/47),SUM((J201)*7/47)),""),""))
  9. ptweb

    DISPLAYING THE £ CURRENCY SIGN

    DISPLAYING THE £ CURRENCY SIGN ,GIVES ME A ? USING Chr(156).... why is this, I just want to display £ but no joy, any help please PT
  10. ptweb

    MULTIPLYING BY A STOCK NUMBER

    Hi I have this query to give me a totalprice... SELECT Sum(products.Price) AS SumOfPrice FROM products; ...how can one alter this so the SumOfPrice is the products.Price multiplied by the stock amount on a different column?? the stock column is called stock... ;-) Many Thxs Gary
  11. ptweb

    USING THE 'WHERE' CLAUSE IN EXCEL

    Hi New to the forum, can anyone tell me how I can use the where clause in a cell in excel... I have another sheet and a column called rowid... I would like to use this rule SUMTOTAL OF CELLS WHERE ROWID = 21 Thxs in advance

Part and Inventory Search

Back
Top