• 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

    Hui...

  • 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

mechechiev

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
 

Attachments

  • Sample.xlsx
    10.9 KB · Views: 9
Hello,

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

=IFERROR(INDEX(3:3,AGGREGATE(15,6,COLUMN($B3:$L3)/ISNA(MATCH($B3:$L3,$M3:M3,0)),1)),"")

Nothing happened, it keeps giving me error. Maybe there is something that I have to add. But thanks a lot for your reply
 
Attached is your sample file. Yellow highlighted is the formula.
 

Attachments

  • Sample (1).xlsx
    11.9 KB · Views: 13
Back
Top