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
 

Hi!

Try this:

=SUMPRODUCT(--(A1:A10="W"),B1:B10+C1:C10*0.01)

Biff

"Eric" wrote in message
...
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
 

Hmmm....

After reading the post again.....

Did you want the total to be in 2 different columns and the cents to be
displayed as a whole number?

Biff

"Biff" wrote in message
...
Hi!

Try this:

=SUMPRODUCT(--(A1:A10="W"),B1:B10+C1:C10*0.01)

Biff

"Eric" wrote in message
...
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)