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)
|