IMAGE and COUNT conundrum

[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

[Pat Stanford]

I think if you SUMmarize column A and then Sum Values in column B you should get what you want.

[Pat Stanford]

If that does not do it, please post the file so we can take a look at what is happening.

 

[MartinBlomberg]

On 3/21/2024 at 9:12 PM, Pat Stanford said:

If that does not do it, please post the file so we can take a look at what is happening.

 

Can't get it to work, I must've missed something really basic I guess... Attached the file here. Many thanks @Pat Stanford!

Tables.vwx

[Pat Stanford]

It looks like VW can not SUMmarize based on an image.

 

Add another column with a formula of =SymbolName and SUMmarize on that.

 

If you don't want the Symbol Name to show, you can set the column width to Zero to hide it.