Hai to all, i want a formula which totals all subtotal values from the list of data
Hai to all, i want a formula which totals all subtotal values from the list of data
Hi, I want more information.
example
product month total
A April 250
B April 500
total 750
A May 200
B May 300
Total 500
ineed subtotal as =750+500=1250 (sum of subtotals)
this i need any solution
are the subtotals obtained using the subtotal() function?
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
in the last cell of same column i need a formula showing link of subtotals
its just example, actually subtotals obtained by sum function. i need the total value of each month to be added in last. and when i click on that cell it should show me from which totals grand total arrived
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks