Hi,
If your 2 columns are A and B, try this:
=SUMPRODUCT(--(LEFT(A2:A20,3)="Tot")*(B2:B20))
Change the ranges to suit your data.
Regards - Dave.
_
Find out what’s new with your friends Download the new Windows Live Messenge
Ankur,
Here is a link to an attendance sheet I made.
I'm not sure it will do what you want.
http://www.scribd.com/doc/6078466/Attendance-History-091708
Norman
On Mon, Mar 30, 2009 at 2:42 PM, ankur lodha wrote:
>
> hi everyone
>
> i've a task to prepare an attendance register of 10 candidates
Hi Raafi,
Please refer to the following link for the explaination:
http://www.techonthenet.com/excel/questions/referencing.php
Hope it helps.
Regards,
Andy
On Tue, Mar 31, 2009 at 4:38 AM, raafi barey wrote:
> Hi..
> I am back again with another doubt..
> what is the difference between
> A$2
Hello Dollar Chande
You can use software called Passware which finds the password for most
of the applications like Outlook, Acrobat including Office. It is easily
available.. just google it.
Regards
Praveen Khunte
DOLLAR CHANDE wrote:
> Dear All,
>
> I have reduced the size of the said f
Hi..
I am back again with another doubt..
what is the difference between
A$2
$A2
$A$2
..
what is the significance of this dollar sign..pls reply..
--~--~-~--~~~---~--~~
-
Some impor
I have a spreadsheet:
Account Amount
a.120 100.00
b.120 50.00
Tot 120 150.00
a.220 75.00
b.220 25.00
Tot 220 100.00
Etc
I want to create a formula at the bottom that adds all lines which
begin with "Tot". I need the actual formula not jus
hi everyone
i've a task to prepare an attendance register of 10 candidates at my office..
i'm stuck in pivot table formation.. I'm attaching the sheet for your perusal..
I want name of candidates in rows.. present / leave / comp off / holiday being
the column header and count of prese
Hi Satish,
Thanks a lot for letting us know that your problem is solved.
Regards,
Andy
On Mon, Mar 30, 2009 at 4:46 PM, satish wrote:
> Hi Mr.Andy
> I appreciate your patience to explain in such a great depth of how to solve
> this problem. Fortunately i am using Office 2007 and the problem go
hi satish
If you are interest in updating data in website , so i am surely
help you with this
not in matter of XML i can do it for you in webbrowser control
please let me know if any assistance are required in using webbbrower
applications
regards
Santosh Bahuguna
On 3/30/09, satish wro
Hello all,
Can somebody help me in implementation of importing the excel data to
datagridView in visualbasic 2005
How can this be done ??
Thank you
--~--~-~--~~~---~--~~
-
Some impo
Pleaes update the workbook
thanks
regards
Santosh Bahuguna
On 3/30/09, Dave Bonallack wrote:
>
> Hi Abdul,
>
> No attached sheet...
>
> Dave.
>
>
>
> Date: Sun, 29 Mar 2009 20:22:50 +0300
> Subject: $$Excel-Macros$$ Help required
> From: abdulhakimk...@gmail.com
> To: findsarfa...@gmail.com; em
Hello,
I have enclosed the copy of xl sheet, hope which will clarify your
question. If you need any clarification or If am wrong please let me know.
Thanks & Regards
--
Vinu
(¨`*.*´¨) Always
`*.¸(¨`*.*´¨) Keep
(¨`*.*´¨)¸.*´ Smiling!
`*.¸.*´
--~--~-~--~~~---~--~---
Hi
Can anyone help how to create an xml file. Some websites allow to
update data if it is in xml format. If xml format is not available the
same website asks to type the data in the cells provided which is very
tiresome. So i wanna learn how to create xml file as per the
requirement of website. A
Hi Mr.Andy
I appreciate your patience to explain in such a great depth of how to solve
this problem. Fortunately i am using Office 2007 and the problem got solved
in seconds
I guess u have proficient knowledge about Excel formulas, Thanks to this
group.
Thank you very very very much
Satish
O
hi i if i send a vba file with password can u break it for me pls its
very important.
On 3/19/09, Harmeet Singh wrote:
>
> Hi Hari,
>
> It is unlocked.
> Password for is "*1*".
>
>
>
>
> On Fri, Mar 20, 2009 at 10:19 AM, hari wrote:
>
>> Hi Harmeet,
>>
>> Enclosed please find the file.
Use pivot table, this will give you the required output, infact more than
required.
On Mon, Mar 30, 2009 at 12:43 PM, satish wrote:
>
> Hello group member
>
> I need an help with respect to "Count-if Function". this is what my
> query is
>
> say in "column A" there are many number of A, B, C
Hi
Sumproduct function can also be tweaked to work for logical operations like
AND and OR
AND is represented as * and OR is represented as + in these scenarios:
http://www.bygsoftware.com/Excel/functions/sumproduct.htm
The above link will answer your queries regarding SumProduct
Regards,
Andy
On
Hi Satish,
If you are using office 2007 then you can easily use the COUNTIFS function:
=COUNTIFS(A1:A23,"a",B1:B23,"c") will check how many "c" are there
corresponding to "a", same thing can be done for "b" as well.
However if you are using Office 2003 or any lower version, then you have no
optio
Hello group member
I need an help with respect to "Count-if Function". this is what my
query is
say in "column A" there are many number of A, B, C (no any sequence)
etc in 1000 rows (one letter in each cell)
Next, in "Column B" there are again many no. of A, B, C etc...
I wanna know how many B
Hi Guys,
What is the password for amt in words in excel add-in.
Pl reply asap.
S.Ashok
On Tue, Mar 24, 2009 at 12:18 AM, harsh shah wrote:
> dear all,
>
> i hope these files might be of some use.
>
> >
>
> AmtInWords.xla is attached to this mail. It is an MS Excel Add-in to
> convert amount
Dear Wizards,
I have a excel file which i tried to mail to the group for providing the VBA
password bt as the size of the file is more than 7MB the mail came
back. Request you to kindly provide a any way out enable me to open the
macro/code, which will enable me to study the macros which could hel
21 matches
Mail list logo
