• 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. F

    sumifs with name

    Thank you i manage to get it work, although the formula doesn't work using Name but I have to specify the value. In my example Name1 was setup taking 3 values A1, A2, A3 i did try =SUMPRODUCT((B2:B50)*(C2:C50>=StartDate)(C2:C50<=EndDate)*(A2:A50=Name1)) but didn't work, so I had to...
  2. F

    sumifs with name

    I have defined a name let's say Accounts which is A1, A2, A3 In column A I have all list of accounts A1 to A10 and B1 to B10 (range A2 to A50) In column B I have the related values (range B2 to B50) In column C I have the related dates (range C2 to C50) I need to sum the value of what I...
  3. F

    Date - Month series

    I need to prepare a financial report whereby given a variable year-end date input in a cell (e.g. A1: 31.03.12)a formula will allow me to have a serie of the next 12 following month. I cannot use A1+30 = 30.04.12 because of course if A1: was 30.04.12 will not work Thank you
  4. F

    Sum data

    I need to sum accounting data where the accounts are identified by a nominal code no. between a data range. Assuming I have the following: account no. A1:A10 (e.g. phone, rent etc) value B1:B10 booking dates C1:C10 (e.g. from 01.04.12 to 30.06.12) I know I can use sumif(A1:A10,rent,B1:B10)...
Back
Top