I feel like a complete moron when I can't get the IMAGE and COUNT-function to do what I want. All I'm after is to get the total amount of tables (exactly the same table and symbol) I have on the drawing and sum the total. I have 44 tables on a drawing and cant' get it to work.
What I want:
Column A: The table symbol
Column B: 44
But, what I get is either:
Column A: 44 rows, with the same symbol
Column B: The number "1"
or
Column A: 1 row with the symbol
Column B: The number "1"
I've tried all combinations of "Summarise items" and "Sum values" but can't get it to work. What will do the trick?
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
MartinBlomberg
Hi,
I feel like a complete moron when I can't get the IMAGE and COUNT-function to do what I want. All I'm after is to get the total amount of tables (exactly the same table and symbol) I have on the drawing and sum the total. I have 44 tables on a drawing and cant' get it to work.
What I want:
Column A: The table symbol
Column B: 44
But, what I get is either:
Column A: 44 rows, with the same symbol
Column B: The number "1"
or
Column A: 1 row with the symbol
Column B: The number "1"
I've tried all combinations of "Summarise items" and "Sum values" but can't get it to work. What will do the trick?
Many thanks!
Martin
Link to comment
4 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.