Help on Excel 2007
This query is : Resolved
10 June 2009
I have doubt in adding cell contents of a row in MS Excell
e.g I have
total
1 2 3 4 5 6 7 8 9 10 From to
Name * * * * * * * * * *
I want a formula so as to add cell contents as =SUM(from:end), WITHOUT giving direct cell reference, but want to give the reference as From: 1, To: 8
so that excell should make a total of data in the row from row"1" to row"8".
I want to have separate two cells where i could directly give these cell references
e.g I have
total
1 2 3 4 5 6 7 8 9 10 From to
Name * * * * * * * * * *
I want a formula so as to add cell contents as =SUM(from:end), WITHOUT giving direct cell reference, but want to give the reference as From: 1, To: 8
so that excell should make a total of data in the row from row"1" to row"8".
I want to have separate two cells where i could directly give these cell references
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
Similar Resolved Queries
Unanswered Queries
- Post Office RD Interest
- Building and other construction workers welfare cess act 1996
- Applicable TDS for Purchase of Flat from NRI
- Eway bill for machinery reparing
- Bank Accounts in Balance Sheet for ITR 3
- ITR 3 FILING OF AN INDIVIDUAL (PARTNER IN A PARTNERSHIP fIRM)
- Annual return of gst limit
- TDS ON CASH WITHDRAWALS...
- Form 10BD Filling
- Registration as Authorised Representative of minor
- ESIC- Employee Registration
- Delisted shares sold in off market/ Rebate u/s87A
- In Exports Sales HSN details where to fill
- Opting out" of regime provided under subsection (1A) of Section 115BAC but Form 10IEA is not filed.
- Difference in tax comparison report
- Gst invoice numbering and delivery challan numbering
- Sales amount in Gstr1
- E Commerce GSTR1 & 3B how to file
- GST Cancellation without jurisdiction
- Legal Opinion on Registrar's Refusal to Investigate a Society for Non-Renewal and Non-Compliance
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
