column-1 col-2 col-3
1 W-1 A
2 W-2 B
3 W-1 A
4 W-2 B
5 W-2 B
6 W-3 D
7 W-3 B
HOW TO FIND NUMBER OF 'A' WITH W-1 AND ALSO NUMBER OF 'B' WITH W-2 AND SO ON..............
waiting for all ur kind feedback
column-1 col-2 col-3
1 W-1 A
2 W-2 B
3 W-1 A
4 W-2 B
5 W-2 B
6 W-3 D
7 W-3 B
HOW TO FIND NUMBER OF 'A' WITH W-1 AND ALSO NUMBER OF 'B' WITH W-2 AND SO ON..............
waiting for all ur kind feedback
Last edited by vijayaragavan; 03-14-2014 at 01:14 PM.
=countifs( $A41:$A$7, a1,$B$1:$B$7,b1)
and copy down
Or you could put the values you want to test for in other cells
hope that helps
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
attached
Attachment 303841
Click on the star if you think I helped you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks