Worksheets
This query is : Resolved
29 April 2011
I have created different worksheet say around 40 sheets for the items imported in which items imported are mentioned,now what formula i should give to have the total summary of similar items in different worksheets pls do the needful it would be very helpful to me
Regards
Girish
Regards
Girish
29 April 2011
It will deepend on what type of summaries do you want. Some simple examples: Suppose you want to know how many times you have imported say A. The formula will be =countif(range of items,"=A"). Similarly if you want the amount incurred on A, you can use sumif: =sumif(range of items, "=A", range of costs)
If you could describe teh desired summaries perhaps one can think of more formulae.
If you could describe teh desired summaries perhaps one can think of more formulae.
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Unanswered Queries
- Taxable or Tax exempt
- CAPITAL GAIN BASE ON NOTIFICATION
- Form 140 tds
- ITDS U/S.194T of Firm
- ADVANCE PAYMENT OF ADVOCATE
- NRI starting business in India
- Eway bill not cancelled within 24 hous what can be due
- EXPORT COMMERCIAL INVOICE HSN CODE
- REGARDING ANNUAL RETURNS FILLINGS OF A COMPANY INCORPORATED ON 28.03.2025
- Demand Outstanding AY 2013-14 TDS Deducted not shown in 26as
- DIN reactivation
- TDS Return Q1 FY 2026-27
- Guidance Needed: Linking Multiple Form 26QB Payments and Responding to ITD Defaulter Notice
- How to pay remaining amount of TDS after due date?
- Resigning a auditor from the company for misconduct
- RCM @ 5% on Hamali charges, Transport Charges, Unloading charges we take ITC or not
- CALCULATION OF DEFFERED TAX - OP BL IS DTL & CURRET IT DTA
- LLP audit under companies act
- Experienced CA recommendation from Kolkata for FNO return filing
- Interest Reporting in Form 168
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
