Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Question | Excel Worksheet Functions | |||
Formula question | Excel Discussion (Misc queries) | |||
I have a question regarding countif formula. | Excel Worksheet Functions | |||
formula question | Excel Worksheet Functions | |||
Formula Question | Excel Discussion (Misc queries) |