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!

Register Log in
  • Congratulations TouchToneTommy 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: *

  1. blarosa

    Nested Sumifs

    Yes--as an array.&nbsp;&nbsp;Assuming the upper left cell is A1, use this formula:<br><br>SUM((B1:B4=&quot;A&quot;)*(C1:C4=&quot;Yes&quot;)*A1:A4)<br><br>And remember to enclose the formula with a ctrl-shift-enter to set up the function as an array.
  2. blarosa

    Excel LOOKUP/INDEX/MATCH, but search for cell properties

    I am looking for a way to use one of the lookup functions to find the first row where the cell is not protected, rather than a particular value as the functions would like.
  3. blarosa

    Interpreting page faults errors in Excel

    Does anyone know of a web site that will help me decipher invalid page faults errors in Office, especially Excel?
  4. blarosa

    Print more than one Excel userform on a page

    I have 3 Excel 97 userforms that I need grouped together when they print, without a page break.&nbsp;&nbsp;Is there a way to do this?&nbsp;&nbsp;I have seen something similar with ranges in PUP 2000.<br><br>Thanks

Part and Inventory Search

Back
Top