Hi On which column you want sum ?
Regards
Prince
On Wednesday, February 27, 2013 5:27:38 PM UTC+5:30, Deepak Rawat wrote:
Hi,
need formula for sum in attach
Regards,
Deepak
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join
Hi Midhun,
Environ(username)
used in VBA to find username of the system.
Regards
Prince
On Monday, January 21, 2013 12:13:51 PM UTC+5:30, midhun wrote:
hi friends;
i need a formula that will tell me about which user has logged in the
particular file
--
Midhun Thampan.
hello suyog,
please try this
:-
=+IF((B2+12)B4,(B7+B10),IF((B2+12)B8,0,IF((B2+12)B4:B5,((B5-B2+12)*(B8/12)
On Friday, January 11, 2013 3:18:13 PM UTC+5:30, Suyog Kulkarni wrote:
Hello All,
Please see attached excel, I'm confused how can I set IF statement based
on varying 3 condition
pl find attached herewith.
Warm Regards,
Anil Gawli
On Tue, Jan 15, 2013 at 1:07 PM, Prince prince141...@gmail.com wrote:
Hi Prabhakar,
paste the following formula.
=SUMIFS(C2:C10,A2:A10,Fax,B2:B10,Brown)
Regards
Prince
On Tuesday, January 15, 2013 12:40:13 PM UTC+5:30, Prabhakar S
Thanks Ton. Its working fine.
Can you also send me materials on macros. i want to learn from the basic.
Rgds,
Prabhakar
On Tuesday, January 15, 2013 3:07:53 PM UTC+5:30, अनिल नारायण गवली wrote:
pl find attached herewith.
Warm Regards,
Anil Gawli
On Tue, Jan 15, 2013 at 1:07 PM,
Sam,
You understood my problem correctly. I think rather using IF, I think we
should try for scenario. I don't know much about this.
My conditions are as follows.
1) PL are applicable after 1yr service.
2) Whoever already completed 1yr he/she will get full PL
3) If somebody finishing his
Hi Prabhakar,
paste the following formula.
=SUMIFS(C2:C10,A2:A10,Fax,B2:B10,Brown)
Regards
Prince
On Tuesday, January 15, 2013 12:40:13 PM UTC+5:30, Prabhakar S H wrote:
Dear Team,
I need to get formula for attached file. Pls help.
Rgds,
Prabhakar
--
Join official Facebook page
Suyog,
It seems that multiple conditions can be met based on certain dates. Can
you double check the variables? The conditions must be independent of each
other for a multiple IF statement to be valid.
On Sunday, January 13, 2013 1:17:56 AM UTC-5, Suyog Kulkarni wrote:
Hello All,
Hi Friend,
Instead of adding all cells just Paste below formula in AE5 and Drag the
same upto AE25 .
Formula Is : =SUMPRODUCT(($C$4:$AD$4),($C5:$AD5))
Regards
Prince
On Monday, December 10, 2012 12:31:47 PM UTC+5:30, excel lerner wrote:
Sir
Please see the sample and help me.In this file
Hi
PFA..
Cheers..
Rgds//Vabs
On Thursday, October 18, 2012 12:32:21 PM UTC+5:30, Manoj Kumar wrote:
-- Forwarded message --
From: Manoj Kumar manoj...@gmail.com javascript:
Date: Thu, Oct 18, 2012 at 12:29 PM
Subject: Need formula to update status
To:
Thanks
On Thu, Oct 18, 2012 at 1:05 PM, Vabz v...@vabs.in wrote:
Hi
PFA..
Cheers..
Rgds//Vabs
On Thursday, October 18, 2012 12:32:21 PM UTC+5:30, Manoj Kumar wrote:
-- Forwarded message --
From: Manoj Kumar manoj...@gmail.com
Date: Thu, Oct 18, 2012 at 12:29 PM
below formula also can use with C+S+E
=IF(MAX(IF($B$2:$B$17=B2,$A$2:$A$17))MAX($A$2:$A$17),Deactivate,Activate)
Aamir Shahzad
On Thu, Oct 18, 2012 at 12:43 PM, Manoj Kumar manoj.11...@gmail.com wrote:
Thanks
On Thu, Oct 18, 2012 at 1:05 PM, Vabz v...@vabs.in wrote:
Hi
PFA..
Cheers..
hi
PFA
Cheers..
Rgds//Vabs
On Tuesday, September 25, 2012 3:16:49 PM UTC+5:30, rajeyssh wrote:
Hello everyone
I need simple average and minimum formula in the column but excluding the
value if 0.
thanks
--
Join official facebook page of this forum @
hi Prashant,
Use this
=INDEX(A2:A4,MATCH(TRUE,LEN(A2:A4)0,0),1) with Ctrl+shift+enter
regards
prince dubey
On Thursday, 12 July 2012 16:50:22 UTC+5:30, ppawle.excel wrote:
Dear All,
Need a formula for getting first text in the Range, in particular cell ,
sample file attached
Regards,
One way may be to manually copy the data from the three columns, one
at a time, into a single column. In the column next to the Product #
column, write a formula to isolate the number:
=VALUE(MID(A2,FIND( ,A2,1)+1,LEN(A2)-9))
where column A contains the list and 9 is the length of the word
Product
1) I have slightly confutationon increment column u need max value
or latest value
2) how to upload Xl file here
On May 26, 6:53 pm, Ahmedhonest ahmedhon...@gmail.com wrote:
Dear Team,
Please help out to frame a Formula for the attach, I need it using the
Worksheet Functions,
16 matches
Mail list logo