complicated sum formula question

[Eric]

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)

[Biff]

Hi!

Try this:

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

Biff

"Eric" <[email protected]> wrote in message
news:[email protected]...
>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)

[Biff]

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" <[email protected]> wrote in message
news:%23Y7bwhI%[email protected]...
> Hi!
>
> Try this:
>
> =SUMPRODUCT(--(A1:A10="W"),B1:B10+C1:C10*0.01)
>
> Biff
>
> "Eric" <[email protected]> wrote in message
> news:[email protected]...
>>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)
>
>