I have different sheets and I have changed their names in a workbook
1<--sheet name
A B (Column)
0:00-0:15 1
0:15-0:30 0
0:30-0:45 0
2<--sheet name
A B (Column)
0:00-0:15 10
0:15-0:30 5
0:30-0:45 6
3<--sheet name
A B (Column)
0:00-0:15 0
0:15-0:30 7
0:30-0:45 8
Total<--sheet name
A B (Column)
2 3
0:00-0:15 10
0:15-0:30 12
0:30-0:45 14
How to make a VBA to do the sumif
If I type 1 under Cell A2 and 3 under cell B2 in sheet (total), I will get the sumif for both sheet 1, 2 and 3.
If I type 1 under Cell A2 and 2 under cell B2 in sheet (total), I will get the sumif for both sheet 1 and 2.
I have used the below but I got no result.
Thanks
Bookmarks