Log In
Register
Home
Countifs
lea cohen
Member
Members
Forum Posts: 237
Member Since:
March 10, 2016
March 10, 2016
Offline1
November 20, 2018 - 5:02 pm
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!!
Velouria
London or thereabouts
Moderator
Members
Trusted Members
Moderators
Trusted Members
Moderators
Forum Posts: 688
Member Since:
November 1, 2018
November 1, 2018
Offline2
November 20, 2018 - 9:07 pm
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)
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Chris Ritcey
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
jaryszek: 183
Newest Members:
Lisa Myers
David von Kleek
Ronald White
Ginette Guevremont
Taryn Ambrosi
Mark Davenport
Christy Nichols
Harald Endres
Ashley Hughes
Herbie Key
Forum Stats:
Groups: 3
Forums: 24
Topics: 6528
Posts: 28594
Member Stats:
Guest Posters: 49
Members: 32818
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen
© Simple:Press —