SUMIF Formula Help

[mgoldie1]

As you can see in cells G2 & I2, I'm trying to do a continuous total from Column A if there is a "1" in Column C, or a continuous total from Column B if there is a "1" in Column D. I want the result to show in either G4 or I4.

I tried this formula in G4, but it didn't work:

=SUM(IF(C:C="1",A:A))

Also, in K4, I want to get the result to show in bold if it's a profit (G4 - I4 is a positive number) or in red if it's a loss (G4 - I4 is a negative number).

Thanks for your help.

Marc


https://www.dropbox.com/s/tsk9gqpnntrn7cp/SUMIF FORMULAS NEEDED.xlsx?dl=0

 

[mgoldie1]

Sorry, I forgot to add K4 in previous sheet. Here it is:

https://www.dropbox.com/s/azlbtplabtnb4mg/SUMIF FORMULAS NEEDED.xlsx?dl=0

 

[AliGW]

Like this:

=SUMIF(C2:C6,1,A2:A6)

and:

=SUMIF(D2:D6,1,B2:B6)

Don't quite understand the second requirement ...

 

[mgoldie1]

Thanks, that worked!!

On the second part, I figured it out. I had to go to Conditional Formatting and if the number is less than 0, it highlights in red.