Unanswered

Excel count function problem

(0) Share

Report

Posted on by BYULBORAHY

I want to count the total numbers of email in the excel sheet then I use the COUNTIF formula to count the total number of @. But it is error. And also there are more than one @ in same cell , how can I count an exact number of emails. Thanks a lot!

All responses (3)

Answers (0)

LokeshBysani 229 Super User 2024 Season 1 on at

Like (0)

Report

Re: Excel count function problem

Its not related to flow I guess. But however I gave it a try and below is the approach
Formula in cell B1: =LEN(A1)-LEN(SUBSTITUTE(A1,";",""))+LEN(A1)-LEN(SUBSTITUTE(A1,",",""))+1
drag this formula till the rows you have data in column B.

This gives the count of emails in each row. Finally you can use =SUM(B:B) formula to get all the emails count.
BYULBORAHY 2 on at

Like (0)

Report

Re: Excel count function problem

I am so sorry for that!
If I want to count how many email in this sheet , how can I do?
I tried to use the COUNTIF formula [=COUNTIF(A1:A3,"@") ], but it will be error.
Thank a lot!
LokeshBysani 229 Super User 2024 Season 1 on at

Like (0)

Report

Re: Excel count function problem

@BYULBORAHY your issue is not clear. If possible share the image of your Excel file with dummy data .
Flow image you created and exactly at which step of the flow you have an issue/difficulty. This information will be helpful to guide you in a better way.