Dear Sir
I use following formulas

SUMIF(range, criteria, sum_range)
in which one range and one criteria

But I have two range and two criteria

range criteria sum_range
A : A “>350” C : C
B : B “=Ram” C : C

How can calculate the above quarries.
u can mail
dharmco@gmail.com

Thanks

what are requirement for registration of labour contractors under ESIC Act in Delhi.
Is there any requirement of 6 months advance contribution payment at the time of registration for labour contractors.
If yes letter detail

Regds
Surender Kumar

Is it not compulsory for Employer to deduct PF of all Employees irrespective of their Basic Salary????

Dear Sir,
my client doing bussiness of web site designing. he have only overseas client. he is geting receipts of rs. 8 to 10 lakhs p.a. is he require to registered under any sales tax or services tax law kindly reply.

sir,

I need some information about section 18(1)(iii) of wealth tax act.
As my client who is a woman having a plot . When she purchsed that plot in 2004 for rs. 600000/-and it was not fall in circle rates.As she has not any knowledge of wealth tax. she has not filed any wealth tax return. after receiving notice for A.Y. 2005-06, 2006-07, 2007-08 from income tax office, she has filed wealth tax return for A.Y. 2005-06, 2006-07, 2007-08 & 2008-09.and paid wealth tax for each year.she has been scutinzed for above three years but no tax has been levied on her. after completion of assessment of above three years. she has received notice for penalty u/s 18(1)(iii). whether she is liable to pay the penalty or not.If yes, plz send some suggestion of preventing from penalty as soon as possible.
plz also provide case law if any.
thanking you.

1.what are the last date of E.S.I & P.F challan deposite ?
2. How many times the E.S.I & P.F return have been submitted in a year & what is the last date's for submission ?
3. In which challan through E.S.I & P.F deposited & what is the name of tetrun form ?

Dear experts,
please tell me the latest & whole treatment of TDS for Transport services availed.
& also provide with the latest TDS Rates.
Thanks

A machining center in a job shop of a local fabrication company has five unprocessed jobs remaining at a particular point in time. The jobs are labeled 1,2,3,4and 5 in the order they enter the shop. The respective processing time and due dates are given in the time table below:
Job number : 1 2 3 4 5
Processing time(days): 11 29 31 1 2
Due date: 61 45 31 33 32

The production manager and the marketing manager of the job shop have different opinion on customer service. The production manager feels that for certain jobs delays are inevitable in the basic structure of the job shop working the loss as Rs.50 per day of delay with respect to delivery date.

The marketing manager feels delay would cost the organization Rs.1000 per day of delay.

Examine the three commonest sequencing rules and state sequencing rule that would satisfy the organization requirement best.

I had filed form 23B for the last year. But due to server problem it was filed three times. Now I want to file form 23B for the current year. But during prescrutiny, an error comes that you have prescrutinise or uploaded STP forms with different financial year.
What is the solution of the problem???
Can Form 23AC be filed without SRN of Form 23B????
Is there any other solution?
Please ans. as it is very urgent

Can u please provide me the defination of Promoter Director, Professional Director and Independent Director