complicated sum formula question
 

I need to sum column B (dollars) and column C (cents) if column A equals a
certain charcter (example W) per each row. For a basic total without the
column A stipulation I created the following formulas to total column B and C
together (this is because I display the dollars and cents as whole numbers)
=SUM(D5:D56)+INT(SUM(E5:E56)/100) for dollars (column B total)
=MOD(SUM(E5:E56)/100,1)*100 for cents (column C total)

complicated sum formula question
 

You can just replace the SUMs with SUMIFs; instead of sum(D5:D56) use
sumif(a5:a56,"W",d5:d56).

"Eric" wrote:

I need to sum column B (dollars) and column C (cents) if column A equals a
certain charcter (example W) per each row. For a basic total without the
column A stipulation I created the following formulas to total column B and C
together (this is because I display the dollars and cents as whole numbers)
=SUM(D5:D56)+INT(SUM(E5:E56)/100) for dollars (column B total)
=MOD(SUM(E5:E56)/100,1)*100 for cents (column C total)