Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version


Try using either SUMIF or SUMIFS. SUMIFS allows for multiple criteria.

In cell C60, =SUMIF(B12:B41,"=1",C12:C41)

This formula will look at B12 to B41, checks to see if there is a 1 (use the quotes even for numerical values), then adds up the corresponding value in the range C12 to C41.