Search results

  1. I

    SumIf (date range in Criteria)

    Is it possible to have a DATE RANGE in the criteria part of a SumIf function? My formula =SUMIF(H2:H576,"<31/12/2009",I2:I576) correctly sums up all payments in column I where the payment date in column H is before 31 Dec. 2009. However, it would be very useful to be able to sum up payments...
  2. I

    Excel Nested If -- help, please!

    Hi, I am trying to complete a nested If function, but have not been successful --but at least it partially works. The attached spreadsheet shows what I want to achieve in column C, i.e. If Column A contains any number except 999 and Column B is not empty, then concatenate (put in spaces) If...
  3. I

    How do I refer to part of a concatenated field?

    Hi, I have a mailing label report with a text box (txtAddress) containing: =[Suburb] & " " & [State]&" "&[PostCode] which works fine. Most postcodes in the database have 4 digits, but a few of the addresses only have a 0 (zero) in the Postcode field. My question: is it possible to suppress...
  4. I

    Compar/find value

    Dear Access Gurus, This is my very first post, but I have searched the Access Forum for a few months and found many valuable tips and solutions. Perhaps someone can help me with the following problem/challenge: In a MEMBERSHIP database, I have a table named POSTCODES, which has the following...
Back
Top Bottom