Hello,
I need a help to calculate Subtotal of combine sumproduct & match column values. I have attached an example spreadsheet. Any suggestion?
Thanks in advance. subtotal_sumproduct.xlsx
Hello,
I need a help to calculate Subtotal of combine sumproduct & match column values. I have attached an example spreadsheet. Any suggestion?
Thanks in advance. subtotal_sumproduct.xlsx
b1=SUBTOTAL(102;B$4:B$20)
to count the values in column B.
use 109 if you want to sum the values in column B.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Thanks oeldere, But i was thinking to use formula to calculate subtotal (with sum) as I have more than 50 columns randomly. How can i solve using the formula?
your question is:
You want to filter on a column and want to see what the result is?
If so, the answer in #2 will work for you.
If not, you have to explain better.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks