Dear Dilip,
Again many thanks for your answer, it helped my a lot to solve my
problem.
Apologies, in first I tried to generalize too much, and I wasn't very
clear ( and my bad english doesn't help)
By the way, even if your syntax helped my, I can't managed to get your
formula working
Maybe if
You are always welcome..!!
Thanks Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Mon, Nov 9, 2009 at 12:36 AM, Deepak Rai daksh1...@gmail.com wrote:
Thanks Dilip for your kind response. It is
First of all many thanks to Dilip and Deepak for the answers!!!
Sadly they don't solve my problem, what I exactly need is one formula
that sum the value only of the first 14th values, and ignore any
further value.
This is a sample of my worksheet:
A B C
Time
Dear Tony,
Earlier you wanted the sum of largest 3 labels which are greater than Zero
and your previous email also confirms the same, reproduced belowP-
**
*I have to find the sum only of the first 3 A that are greater than zero*
Now as you have changed the requirement and need sum of 14 values,
Hi Dilip,
Just wanted to know your formula in detail, I tried this formula also
=SUMPRODUCT(($A$1:$A$11=$E$1)*($B$1:$B$110)*($B$1:$B$11)) , which is giving
me the same result. I passed two criteria first is A1:A11 = E1 second one
is value greater then 0. Please explain for my knowledge please.
Hi Tony,
Used array functionality with some nested Excel function and got the desired
result.
Look at the attached workbook which contains the scenario given by you along
with the solution.
Let me know in case of any queries.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Hi,
Please find the enclosed attachment, hope this will help.
Regards,
Deepak
On Fri, Nov 6, 2009 at 9:35 PM, Tony from Work xerses...@gmail.com wrote:
Hello!
Given 2 unsorted columns I'm trying to find a formula that gives me
the sum of the first 3 values greater than zero and equal to
