• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

how to subtract only the different cells from a row


New Member
Hello all,
can you help me with one simple table please. I have simple table with two rows, one is with number and other is with text. I need to calculate each text sums. I attached one sample with sumif but I need other formula for the colors. Please help, Thank you



New Member

Assuming you are using Excel 2010 or higher. In N3, then copy across.

Nothing happened, it keeps giving me error. Maybe there is something that I have to add. But thanks a lot for your reply