LinkBack URL
About LinkBacks
Sum content of row's column's C value (C1 C2 C3) if row contains the cells called "Money" and "Euro"
Sum content of row's column's C value (C1 C2 C3) if row contains the cells called "Money" and "Euro"
Last edited by frank35; 11-19-2013 at 11:57 AM.
Where would "Money" or "Euro" be - in one specific column or anywhere in the row? If it's the former try looking at SUMIF function, e.g.
=SUM(SUMIF(A:A,{"Money","Euro"},C:C))
Audere est facere
sorry, looking for a macro here
Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
sorry this is not what I asked for, I need a macro that does this.
This is a macro.
yes, thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks