Thanks:  0
Likes:  0

# Thread: Summing up values with a special condition

1. Hello,

I've got a row with YES or NO in every cells and I would like to sum up all the values under the NOs with the first Yes, until it reaches the next YES. How can it be done?
Ex.
YES NO NO NO ¦YES NO NO ¦YES...
Values 5 5 10 10 ¦15 10 15 ¦5
>Result 30 ¦40 ¦...

Hope you understand. Thank you in advance for you help.
Fred.

2. On 2002-03-07 08:04, FCH wrote:
Hello,

I've got a row with YES or NO in every cells and I would like to sum up all the values under the NOs with the first Yes, until it reaches the next YES. How can it be done?
Ex.
YES NO NO NO ¦YES NO NO ¦YES...
Values 5 5 10 10 ¦15 10 15 ¦5
>Result 30 ¦40 ¦...

Hope you understand. Thank you in advance for you help.
Fred.
Lets say that A1:H1 houses the YES/NO data and A2:H2 the corresponding values:

In A3 enter and copy across till H3:

3. On 2002-03-07 21:54, Aladin Akyurek wrote:
On 2002-03-07 08:04, FCH wrote:
Hello,

I've got a row with YES or NO in every cells and I would like to sum up all the values under the NOs with the first Yes, until it reaches the next YES. How can it be done?
Ex.
YES NO NO NO ¦YES NO NO ¦YES...
Values 5 5 10 10 ¦15 10 15 ¦5
>Result 30 ¦40 ¦...

Hope you understand. Thank you in advance for you help.
Fred.
Lets say that A1:H1 houses the YES/NO data and A2:H2 the corresponding values:

In A3 enter and copy across till H3:

Great, it works. Thanks a lot.

## User Tag List

#### Posting Permissions

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