complicated sum formula question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Complicated SUM IF formula 2
Having cells default to 0 2
SUM formula results returns 0 value 7
Conditional Formulas 8
Working out a value within a certain month. 14
Sum Function Visible Cells only 5
Sumif (sum if question) 5
Automatically add lines and keep formulas 2

Back
Top