Results 1 to 7 of 7

Thread: Formula to Counting Customer Sums

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Neophyte sfaheather84's Avatar
    Join Date
    Jun 2019
    Posts
    3
    Articles
    0
    Excel Version
    Office 365 MOS

    Formula to Counting Customer Sums

    Example file attached. I am trying to count the number customers in 2017 that total for 2016+2017 fall into the threasholds in A26 to A32 (greater than or equal to the amount, but less than value above) without adding a helper column.

    For example, at the 80k level, the formula would return three customers as customer I-K totals are >= 80k, but < 100k.

    The full result would be
    100k - 5
    80k - 3
    50k -8
    36k - 0
    25k - 0
    12.5k - 0
    1 - 1
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •