• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. C

    Calculation speed slows down with SUMPRODUCT formulas

    Using Sum if as an array is an alternative for 2003 users. i.e =SUM(IF(Plant=$B8,if(InvoiceDate>=U$4+1,if(InvoiceDate<=V$4,InvoiceAmount)))) - remembering to press CTRL + SHIFT + ENTER. Might be quicker?
  2. C

    Countif/Sumif with linked workbook

    Thanks both, useful info about the SUMPRODUCT. I've managed to get the COUNTIF to work using an array formula i.e {=count(if('Z:....YF218.xlsb'!A2:A10000=A1,'Z:......YF218.xlsb'!A2:A10000))}
  3. C

    Countif/Sumif with linked workbook

    Hi, When linking a spreadsheet to another workbook using a countif formula, the spreadsheet requires the linked workbook to be open for the formula to work. If the linked workbook is closed, VALUE is returned in the formula. Not sure if this a quirk to 2007 or otherwise. Has anybody else...
Back
Top