Hi guys
I think this is an easy one for you. I cannot get there...
I have 2 columns to sum only in those lines they're diferent values.
I did a comparation between 2 columns, and i want the sum of column G if the value is different on column H.
I've attach a file
Hope you understand that would be a great help for me.
Tks in advance
Pedro
Try in F12:
=SUMPRODUCT((F5:F10<>G5:G10)*F5:F10)
G12:
=SUMPRODUCT((F5:F10<>G5:G10)*G5:G10)
Quang PT
Try these two array formulas
for column F
Formula:
Please Login or Register to view this content.
For G
Formula:Please Login or Register to view this content.
***Array formula must be entered by using key combination of CTRL+SHIFT+ENTER and not just ENTER
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Try
=SUMPRODUCT(--($G5:$G10<>$H5:$H10),G5:G10)
I'd go with:Formula:Please Login or Register to view this content.
Edit: missed the second one:
Formula:Please Login or Register to view this content.
Regards, TMS
Last edited by TMS; 11-09-2015 at 11:48 AM.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Guys
Many thanks for all your help
Best regards
Pedro
You're welcome.
Ditto. You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks