SUMIFS UNTIL the number is repeating

  • Thread starter augustodelucena
  • Start date

A

augustodelucena

Hi folks!

I went through a non turnig-back situation with my Excel formulas and I am running in cyrcles since then.

I got to a point where I can't go further and I beg for help.

What DO I need is very simples and I would be grateful to have a solution or even a denial about Excel limitations.

I have the following figures in my spreadsheet and I have been trying to use SUMIFS. However, I don't want to count values in a continous way, rather than that, I need to count the values ONLY until the number that is being counted is being repeated.

Example:

Spreadsheet from Column Q1 to Column Q6:

Q1 Controlling

Q2 8

Q3 8

Q4 8

Q5 8

Q6 8

On this case, the Excel would count the number 8 five times in this array. However, If there were more number just below the number 8, it would count them as well.


Q1 Controlling

Q2 8

Q3 8

Q4 8

Q5 8

Q6 8

Q7 5

Q7 8

What do I need is not to count them when the number being counted has stopped to appear eventhough it can be found at Q7.

For my needs the answer should be that the number 8 was counted 5 five times rather than 6.

I would appreaciate any further assistance.

Regards.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIFS ONLY UNTIL the number REPEATS 1
Sumif 3
SUMIF and SUMIFS Error 3
How to count the number of times a number is repeated in a column 2
Page Number in Repeat Rows area 8
sumifs 1
sumif 8
SUMIF 4

Top