Count if with two criteria excel vba

Posted by Manasa J on Stack Overflow See other posts from Stack Overflow or by Manasa J
Published on 2013-11-06T15:38:28Z Indexed on 2013/11/06 15:53 UTC
Read the original article Hit count: 146

Filed under:

can some one help me create a macro for the following Data.The values in GradeA,GradeB etc.. columns need to be populated by checking sheet1 ColumnB(Student Name) and columnH(Grade).I need both row wise and Column wise total.

Student GradeA  GradeB  GradeC  GradeD  GradeE  GrandTotal
Std1    1        0      2       0       0       3
Std2    0        0      0       1       1       2
Std3    1        0      1       0       0       2 
Std4    0        2      0       3       0       5  
Std5    0        1      2       1       0       4
Std6    1        0      2       0       2       5
Grnd    3        3      7       5       3      21

© Stack Overflow or respective owner

Related posts about excel-vba