Hi everyone,
First of all, I try to explain what is my question exactly,
Assume that you have 10 columns, horizontally, A1 B1 C1 ... and you want to sum values just under the this columns, if A1=true, B1=true..
in the attachment, i just want to sum values under the Micheal and write in respectively L4, L5,L6..... (there are the formulas also placed)
Please let me know if there is any black point.
Thanks
Last edited by asdasdzxc; 06-26-2012 at 10:31 AM.
Wrong answer as many columns have same heading
EDIT post deleted wrong answer
Last edited by Pepe Le Mokko; 06-26-2012 at 12:15 PM. Reason: addendum
Pepe, i dont really got what's your point
does anyone know that fonction?
Which is the correct result for Micheal and why?
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.
If you're wanting to sum only the values for Micheal, then this formula in L3 and copied down:
Formula:
Please Login or Register to view this content.
Or maybe to sum all of the columns for "Micheal"
This array formula
Confirm with Ctrl+Shift+Enter not just Enter
Please Login or Register to view this content.
Or use this ...
Please Login or Register to view this content.
Last edited by Marcol; 07-03-2012 at 09:02 AM.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
@ Cutter & Marcol
Are my English really so bad?..or you just try to guess what OP, means?
Don't worry Fotis, I think it's "B".
I'm going by the "sum values under the Micheal and write in respectively L4, L5, L6" part of the OP.
So, Cutter, this is good news for my English
@ Fotis
Not so much a guess, as a "guesstimate", based on our years in this forum!
The description given has to be read a few times to see the problem.
Cutter is probably correct based on Post#1.
I threw in my suggestion based on the thread title, and assumed that asdasdzxc would probably want to total Cutters' results.
@Fotis
Either your English is good, or mine is bad. Either way, we can understand each other.
Marco...Marcol..as usual!
"guesstimate" is not in Google Translate but i know(i feel) what you say!
I read many times the question and this is the reason that i asked for explanations. Of course both of you as you are so many years in the forum, you "smell" better than me
@Cutter. This is the important!
Now that may have lost something in the translation.you "smell" better than me
You have more experience. You have seen mutch more threads, so you "forebode" the corect answer.
Is this better?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks