SUMIF with check mark

Marcy

I have a column (Have we paid for this container?) and it contains checkmarks. I want to add up the total cost in another column (Cost) IF the checkmark is checked in the other column. This is what I have come up with, I get the #Unparseable error. Where am I going wrong? 

 

 

 

=SUMIF([Have we paid for this container?]1:[Have we paid for this container?]100, 1)([Cost]1:[Cost]100)

 

 

Thanks!

J. Craig Williams

=SUMIF([Have we paid for this container?]1:[Have we paid for this container?]100,1,[Cost]1:[Cost]100)

 

=SUMIF(RANGE  , CRITERIA  , SUM_RANGE)

 

You had )( instead of a comma.

 

Craig

Marcy

Oh of course! Thank you thank you, that worked perfectly.