Conditional Formatting

  • Thread starter Thread starter JC
  • Start date Start date
J

JC

New to this....

I have a list of dollar amounts in column A. In column B, a 1 or 2 (yes or
no) depending on whether the bid was awarded or not. I need to create a
running total everytime a 1 is added to column B that equals the total of the
dollar amounts next to each "1".
 
=SUMIF(B:B,1,A:A)
will work provided the columns have nothing else in them but the data for
this topic.
Otherwise, somethink like this with your actual ranges
=SUMIF(B1:B100,1,A1:A100)
BTW, this is not 'formatting' - that only changes the appearance of things.
You need a formula to conditionally sum a range
best wishes
 
Back
Top