SOLVED

# Count based on column drop down text

Copper Contributor

# Count based on column drop down text

Hi,

In my SharePoint list, I have 10 dropdown columns. (Accept, N/A, & Pending) is the selecting value in each column drop-down.

I would like to count the Total accept, Total N/A, and Total Pending in the individual calculated column.

Can anyone suggest to me the formula, to calculate individual total count, please?

Thanks

Sunil

2 Replies
best response confirmed by sunilkumarkhanapure (Copper Contributor)
Solution

# Re: Count based on column drop down text

@sunilkumarkhanapure you'd need a calculated column for each of the Accept, N/A and Pending and the formula in each would be like this:

=IF(Column1="Accept",1,0)+IF(Column2="Accept",1,0)+IF(Column3="Accept",1,0)  etc etc for all the columns.

Then do the same for N/A and Pending:

=IF(Column1="N/A",1,0)+IF(Column2="N/A",1,0)+IF(Column3="N/A",1,0)

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

# Re: Count based on column drop down text

@RobElliott, thanks for your feedback, must appreciated, it works..