nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

"countif" in Confluence Tables

Steven Leysen

Hi!

I've been giving Google a quick whirl if it's available, but I can't seem to find it and hopefully I get a quick answer here

Does anyone know if there is a plugin that allows me to use a countif("value"=whatever) in tables, in confluence?

Basically the same as the COUNTIF(...) function in Excel.

Already came across a plugin for filtering tables and with this one I could eliminate the use of yet another tool in our Company wiki page.

Thanks!

Steven
Esko

Accepted answers

Steven Leysen

I recently checked this with our confluence go-to guy, according to his knowledge the tables inside of Confluence see text as text and can't use it as cell values. (which makes sense)

Or there is some plugin we don't know about.

All comments

Dong Nguyen

We have the same question. We would like to create some basic Excel functions that can work directly in Confluence pages.

Macro is good but we need to know how to interact with page's content.

Steven Leysen

I recently checked this with our confluence go-to guy, according to his knowledge the tables inside of Confluence see text as text and can't use it as cell values. (which makes sense)

Or there is some plugin we don't know about.

Andrey Khaneev _StiltSoft_

Hi!

There is a Table Filter add-on that can solve your problem in two different ways:

Using Table Filter macro - you can filter table by value and get count of relevant rows. Look at this screenshot
Using Pivot Table macro - this macro will calculate all unique values in a selected table column and will show count of each one. This macro can be combined with Table Filter macro if you need.

Hope it will help.

ahmed koutb

Andrey Khaneev

thanks for this helpful answer

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

app

ms-excel

table

count

function