Skip to main content

How to COUNTA in a single row?

K

Hi all!

I’m looking for a formula solution that will enable me to either:

  • Count all of the "http"s in a single row OR
  • Count the number of non-empty URL field types in a row.

Current code:
CONCATENATE(COUNTA(“https”)," / ",IF({Advertising allowance}=“Daily”, “30”,IF({Advertising allowance}=“Weekly”, “4”,IF({Advertising allowance}=“Bi-Monthly”, “2”,IF({Advertising allowance}=“Monthly”, “1”)))))

    2 replies

    J
    Forum|alt.badge.img+4

    Assuming the URLs are all in individual fields…

    Try the following: COUNTA({URL Field 1}, {URL Field 2}, {URL Field 3})…

    If you have a lot of URL fields, it may also be worth looking at whether they should be in a linked table instead of having multiple columns.

    K
    • Kiza_McDonald
    • Author
    • New Participant
    • 1 reply
    • October 7, 2018
    Julian_Kirkness wrote:

    Assuming the URLs are all in individual fields…

    Try the following: COUNTA({URL Field 1}, {URL Field 2}, {URL Field 3})…

    If you have a lot of URL fields, it may also be worth looking at whether they should be in a linked table instead of having multiple columns.


    Thanks Julian!

    That’s exactly what I ended up doing as I thought through it more.

    Reply


    Most helpful members this week

    Terms & Conditions