I want to count the present days for employees whose branch is in row and dates are in columns. So guide how to add countifs formula for rows as well as columns
Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...
chandoo.org
How to get the Best Results at Chandoo.org there are many sentences, which You seems missed.
I want to count the present days for employees whose branch is in row and dates are in columns. So guide how to add countifs formula for rows as well as columns
It is possible to use COUNTIFS and similar functions over a 2D range but all the criteria ranges must have the same dimensions. Thus = COUNTIFS(register, employee)
might give the number of occurrences of a given employee name within a two dimensional grid.
To return results from a given branch, XLOOKUP could be used to return data specific to a particular store prior to the count = COUNTIFS(
XLOOKUP( branchName, branch, register ),
employee )
So far, this is a very general query; hence a somewhat non-specific reply.
