Sum cells flagged by other cells

[Ian]

I need to know how to sum cell values in column b, if the corresponding
row in column c value is equal to 1. Column B contains the data, column
C contains flags to use or not use the data. All help is greatly
appreciated.

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***

 

[Peo Sjoblom]

=SUMIF(C2:C50,1,B2:B50)

 

[Arvi Laanemets]

Hi

=SUMIF(C:C,1,B:B)