SUMIF Formula Help

mgoldie1

New Member
Joined
Apr 18, 2017
Messages
14
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
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
Like this:

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

and:

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

Don't quite understand the second requirement ...
 
Last edited:
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top