# If Column is X / then take sum of cell and divide by other cell

Options
edited 07/09/21

I am looking for a formula that IF the cell in the column is "yes" then take the sum of associated cell's number and divide it by another cell. Can anyone help?

• ✭✭✭✭✭✭
Options

Please try the following formula and you can scrolled it down to calculate the other rows because i fixed the main cell that you divide the number on ( \$9,912,839.00 )

=IFERROR(IF([Data in Sparklight]@row = "Yes", [Planned Investment]@row / \$[Planned Investment]\$2), "")

the following screenshot shows the result:

bassam.khalil2009@gmail.com

• ✭✭✭✭✭✭
Options

Hi @Tori Scholly

Hope you are fine, Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.

bassam.khalil2009@gmail.com

• Options

@Bassam Khalil See image below!

In column "test" if "data in" column is yes then I want the associated monetary amount from planned investment divided by the the parent number (the \$9,912,839)

• ✭✭✭✭✭✭
Options

Please copy the formula you are using here to check why it's give you this error

bassam.khalil2009@gmail.com

• edited 07/09/21
Options

@Bassam Khalil Here is what I have right now. I tired this one not sure if that is the right track.

=IF(Data in@row = "yes", [Planned Investment]@row / [Planned Investment]2)

• ✭✭✭✭✭✭
Options

Please try the following formula and you can scrolled it down to calculate the other rows because i fixed the main cell that you divide the number on ( \$9,912,839.00 )

=IFERROR(IF([Data in Sparklight]@row = "Yes", [Planned Investment]@row / \$[Planned Investment]\$2), "")

the following screenshot shows the result:

bassam.khalil2009@gmail.com