Start Free TrialLog in
Avatar of Tom M
Tom M

asked on 

Count formula question

Please take a look at the formula in column g, I have something wrong with it the ones in red should be increasing the # of customers shared by 1 in each for each occurrences that a new customer ID is added despite the customers all coming on line at the same point test.xlsx
Microsoft ExcelMicrosoft Office
Avatar of undefined
Last Comment
Tom M
Avatar of Tom Farrar
Tom Farrar
Flag of United States of America image
Your problem is highlighted in yellow.  You formula said greater than and these are equal to

test (4).xlsx
Avatar of Tom M
Tom M

ASKER

Did you mean to provide the corrected formula?  I am not seeing any change between your response and the original?
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image
What results do you expect in the red cells?
ASKER CERTIFIED SOLUTION
Avatar of Tom M
Tom M
Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Microsoft Excel
Microsoft Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts

  • "Invaluable tool for our organization"

    Josh Regalski

  • "Your help has saved me hundreds of hours of internet surfing."

    @fblack61

  • "Just a dang good service!"

    @golferski

  • "Worth every penny."

    Steve Hougom

  • "It’s been a life saver."

    Maria Halt

  • "Best support site I’ve seen!"

    Bob Schneider

  • "I would be lost without them."

    @fblack61

  • "Saved my job multiple times."

    Walt Forbes

  • "I love this site."

    Maria Duwe

  • "Friendly respectful help."

    Andrew Kowtalo

  • "Such top-notch experts."

    @magento

  • "The best money I have ever spent."

    @rwheeler23

  • "Beyond any comprehensible value"

    George Morris

  • "Invaluable tool for our organization"

    Josh Regalski

Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo
© 1996-2023 Experts Exchange, LLC. All rights reserved. Covered by US Patent