Get the count of rows in Google Sheet by matching 3 columns at once

[Praveen]

How can I get the count of rows in Google Sheet by matching 3 columns at once?

For example, in the screenshot below, I want to get the count for rows that match _all_ of the following conditions:

( The result is 3 )

Sender: [email protected]
Recipient (To): [email protected]
Notification: Yes

 

[Supreme]

Hey @Praveen

Please allow us some time, we are currently looking into your use case. We need to do some testing and have to arrange the data according to your concern.

 

[Supreme]

Hey @Praveen

We looked into your concern and currently, there is no formula available to count the specific words from an array according to the rows coming from your Google Sheets.

 

[Praveen]

@Supreme What can be counted from an array?

And what array formulas are available?

 

[Supreme]

Hey @Praveen

You can check the formulas on the list mentioned below -

Spreadsheet Formulas inside Pabbly Connect | Pabbly

Pabbly Connect supports tons of Spreadsheet functions. Most of the functions supported by Excel or Google Sheets can be used directly inside Pabbly Connect.

www.pabbly.com

Google Sheets formulas to count.

Google Sheets function list - Docs Editors Help

 

[Praveen]

@Supreme The Google Sheet formulas can't be used inside Pabbly Connect unless they are also listed in the 1st link you posted, correct?

 

[Supreme]

Hey @Praveen

But it wouldn't take the counts from each row which contains 3 specific words. We tried several possible works around and it is not giving the desired counts.

So, unfortunately taking the counts with 3 specific works from the rows might not be possible.

 

[Praveen]

Okay