Dear XLS
Can you give me this amazing formula in Excel 2003.I use Excel 2003
Regards
Amar
On Thu, May 30, 2013 at 2:10 PM, Chaya chayamon...@gmail.com wrote:
Thanks priti for your formula, it will be a new learning era for me with
varities of formula knowledge.
Regards,
Chaya
The
Dear xlstime
In file formula show #NUM! error.Pls see it.
On Fri, May 31, 2013 at 6:44 PM, xlstime xlst...@gmail.com wrote:
Hi Amar,
PFA or excel 2003
.
Enjoy
Team XLS
On Fri, May 31, 2013 at 4:32 PM, amar takale amartak...@gmail.com wrote:
Dear XLS
Can
use sumifs with index and match combination..please find attached solution
.
Enjoy
Team XLS
On Thu, May 30, 2013 at 1:03 PM, Chaya chayamon...@gmail.com wrote:
Dear Experts,
I was trying to find the values from Rows and coumns which match the
criteria from
Thank you so much Dear Xls. I was amazed you have used sum function,
Actually i thought of sum function is used in only in numerical values
calculation. today i came to know it is used in many calculation. thank you
for that.
Thanks to all.
Regards,
Chaya
The excel learner :-)
On Thu,
try this
=SUMPRODUCT(N($A$2:$A$83=$T$8)*N($B$2:$B$83=$U$8)*N($C$2:$C$83=$X9)*N($D$2:$D$83=Y$8)*INDEX($A$2:$P$83,,MATCH($V$8,$A$1:$P$1,0)))
On Thu, May 30, 2013 at 1:57 PM, Chaya chayamon...@gmail.com wrote:
Thank you so much Dear Xls. I was amazed you have used sum function,
Actually i
Dear XLS,
It is very useful formula and nice formula I was trying the same with
sumproduct ...but it not happen...
first time i have seen sumifs formula with index and match formula.
Regards,
Prafull Jadhav
MIS executive.
On Thu, May 30, 2013 at 1:57 PM, Chaya chayamon...@gmail.com wrote:
Thanks priti for your formula, it will be a new learning era for me with
varities of formula knowledge.
Regards,
Chaya
The excel learner :-)
On Thu, May 30, 2013 at 2:05 PM, Prafull Jadhav prafulltjad...@gmail.comwrote:
Dear XLS,
It is very useful formula and nice formula I was
