I need someone to help me develop a formula for the below circumstance:
- A list of dollar values ranging between $1,000 - $3,000
- Count and sum the number of values between $1,000 - $1,200, $1,201 - $1,400 etc.
59 freelancere byder i gennemsnit $19/time for dette job
I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]
Hi, I can write the formula that you need to count values according to the limits that you set. I can give you the file back in 1 hour. Best regards, Florin Enache.
Hi, you can use below formula (for example you data are in the col A): =COUNTIF(A:A,">999")-COUNTIF(A:A,"<1201") + COUNTIF(A:A,">1200")-COUNTIF(A:A,"<1401")