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
- Is this income indian or foreign income?
- ITC temporary reversal and reclaim
- GST on export of services and Input Credit
- RCM applicability on Rent Paid by Registered Person to Unregistered Landlord for Residental Building
- Inventory of finished goods
- Applicable TDS rate for sale of property in Nov 2024
- Confusion around Form 26QB fields
- Sale of property furniture sale
- REGARDING 25 AS DATE OF PAYMENT AND DATE OF BOOKING
- Quiery in relation to GST liability in case of an advocate who has obtained GST registration.
- BUYING PROPERTY COULD NOT FILE 26QB
- Gst input for FY 23-24
- Regarding Waiver of Interest levied u/s 50 of PGST/CGST Act
- LAST YEAR 2022-23 ITC IN NEXT YEAR 2023-24 REPORITNG IN GSTR-9
- MIS MATCH OF INVOICE NUMBER
- IGST Credit-Show cause notice issued-confusion
- Issue of gst e invoice
- How to adjusted advances given or receipt
- Foreign vendor without PAN unable to to register due to non receipt of OTP on foreign number ?
- 133(6) DIN INVALID format error - ->WHERE TO REPLY 133(6) notice?
Trending Online Classes
CAclubindia
