I have one table as below
Sr No. Grade c1 c2 c3 c4
1 A1 Yes No No Yes
2 A2 No Yes Yes Yes
3 A3 Yes No Yes No
4 A5 No Yes No Yes
5 A3 Yes No Yes Yes
6 A1 No No Yes No
7 A3 Yes Yes Yes No
Now I need to calculate how many total "Yes" c2 cloumn is having when Grade is A2 or A3.
Thanks in advance
=SUM(COUNTIFS(D2:D8,"Yes",A2:A8,{"A2","A3"}))
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks