Hi,
For understanding purpose, lets assume we have B2 instead of B2:B13, fine.
The Text function formats the value (first parameter) according to the
format (the second parameter). So actually the first time we use text()
function, it actually tests if the cell (B2) has the value that matches the
f
HI Ajit.
I sincerely appreciate your solutions and your contribution to this group.
looking at your solution I want to know what does this formula means and how
it works
=SUM(IF(TEXT(B2:B13,"[EMAIL PROTECTED]/000\/00*
")=B2:B13,IF(ISERR(SEARCH("/",TEXT(B2:B13,"[EMAIL
PROTECTED]/000\/00*")))=FALSE
Pls find attached the file
Regards
Ajit
On Sat, Oct 18, 2008 at 2:08 PM, Ahmedhonest <[EMAIL PROTECTED]> wrote:
>
> Dear All,
>
> A warm Greetings to all. Please find the attach file to this mail and
> request you all Guys to provide me the solution and have patients in reading
> the file t
Dear Ahmed,
You can use a very simple "If" formula.
Consider the first admission."NSA/250/30. Just type the following in your
sheet - "=if(B2<>0,D2,0) and then copy the formula. Take the sum of this
column.
Regards,
Nikhil.
On Sat, Oct 18, 2008 at 2:08 PM, Ahmedhonest <[EMAIL PROTECTED]> wrot
Try this
From: excel-macros@googlegroups.com [mailto:[EMAIL PROTECTED]
On Behalf Of Ahmedhonest
Sent: Saturday, October 18, 2008 11:38 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Request for Formula
Dear All,
A warm Greetings to all. Please find the attach file to th
