Announcement

Collapse
No announcement yet.

Search Result

Collapse
2 results in 0.0148 seconds.
Keywords
Members
Tags
  • You can also choose from the popular tags.

sumif x

  • awilkins
    started a topic Merge Duplicates then Sum and Count values

    Merge Duplicates then Sum and Count values

    I often need to merge multiple occurences of data (tax addresses & tax names) and to sum or count the values associated with each invividual instance (i.e number of units per tax address). Data can often be thousands of rows and varies every time. I would like to keep all of the associated information with each entry for mailing purposes. I saw this link...
    http://www.ozgrid.com/forum/showthread.php?t=83101

    However, the VBA macro, when run, only keeps my tax address an the associated sum. Please let me know if there is a way to alter the code to make this possible. I will attach the file I am working with....
    See more | Go to post
    Last edited by AAE; May 26th, 2010, 04:47. Reason: Amend thread title

  • shrodekill
    started a topic Sum by variable date criteria

    Sum by variable date criteria

    Hello, I have been looking around for a way to do this and haven't quite found what I am looking for. I have a list of entries, each with a date and a number associated with that date. Currently, these dates are stored as Excel dates, and I would like to keep it that way if possible. What I am trying to do is do something like this "=SUMIF(Sheet2!A2:A16, "1/1/2009",Sheet2!B2:B16)", but instead of it needing to be the first of the month, I would like to have any day of the month be valid. However, =SUMIF(Sheet2!A2:A16, "1/*/2009",Sheet2!B2:B16) does not work, likely due to the value actually being a simple date number.

    I imagine this is possible using SUM(IF()), but I could not figure it out.

    Any help would be greatly appreciated,...
    See more | Go to post
    Last edited by AAE; May 25th, 2010, 04:37. Reason: Amend thread title
Working...
X