Forum

Notifications
Clear all

Countifs

3 Posts
3 Users
0 Reactions
61 Views
(@usb)
Posts: 244
Honorable Member
Topic starter
 

hi,

In the attachment I set the Countifs function
That calculates the two cells
Endrulf
buy
The question is how to define now that it will be considered the whole of Endrulf
Without changing the Countif function
In other words, how do you define that the verification of the data of the buy will be written all-
Then it will be considered as the Endrulf

Thank you!!

 
Posted : 21/11/2018 3:02 am
(@debaser)
Posts: 837
Member Moderator
 

I'm not really clear on what you mean, but perhaps you want the wildcard * which will match any text in the specified field? (Note: it will not match a blank field, but you don't have any of those in your sample)

 
Posted : 21/11/2018 7:07 am
(@sunnykow)
Posts: 1417
Noble Member
 

Hi lea

Just enter an asterisk (*) into cell N3

Sunny

 
Posted : 21/11/2018 11:36 am
Share: