Share via

Find the first value from a column

Anonymous
2021-10-31T21:59:33+00:00

Hi, guys,

Is there a formula which can be placed in the F column which can find the first value from E column whenever there's a value in C column? For example, the formula from F1 cell should add in the F1 cell the value from E2 cell, which is 456 and that's because I have a value in C1 cell. The value from E5 cell should be ignored. In the F7 cell, the formula should add the value from E8 cell which is 452 and that's because there's a value in C7 cell. The values from E10 and E11 should be ignored. The other cells from the F column should be empty ("").

Below is a sample from the table.

Can you help me, please?

Thank you!

Microsoft 365 and Office | Excel | For home | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

11 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-11-02T02:15:14+00:00

    Hi,

    I asked the same question on the Apple forum for Numbers, and I received the formula for both Numbers and Excel.

    Thank you for your message.

    0 comments