Professor Excel

Comments 1

  1. Peg

    How does sum if work in conjuction with =right?

    When I save a Profit and loss report in pdf format as an excel workbook, it puts words and dollar amounts in one cell. In excel, I use the formula =RIGHT (cell, digits) to copy the last 9 digits (ie the dollar amounts) to the new cell. That way, I have the words (eg Revenue) in first column and dollar amounts (eg $100,000) in the second column. It makes the dollar amounts text, so I have to change the format from text to number.

    When I use =SUMIF to sum various items on the P&L (eg travel meals and entertainment meals), sum if doesn’t recognize the dollar amounts as numbers.

Leave a comment

%d bloggers like this: