help 2 criteria matching
Hi
I'm Currently stuck with this problem, all inputs will be very much appreciated.
OK heres the problem, i have altleast 2 culumns i want to match colum A(COACH), and B (Attendance). what i want to is to return the number of "YES" in a given cell (A1).
COACH-----------------Attendance
Bill --------------------------Yes
John-------------------------No
ryan ------------------------Yes
Last edited by ytja12; 08-26-2010 at 04:45 AM.
Look at SUMPRODUCT
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
ok thanx i manage to solve it
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks