Can anyone tell me how to do this:
I need a formula/macro to check if there is an entry in say column G, if so, add any other entries in the row it was found and do a sum, and continue to check through the column and sum up all the values it has. but i need it to do it across 12 sheets. Quick example.
G H I
1 24 2 1
2 20 1
3 3 2
4 1
5 3 2 2
So when this functions does its thing I get the combined sum of rows 1,2 and 5 = 55
Thnx in advance =)
I need a formula/macro to check if there is an entry in say column G, if so, add any other entries in the row it was found and do a sum, and continue to check through the column and sum up all the values it has. but i need it to do it across 12 sheets. Quick example.
G H I
1 24 2 1
2 20 1
3 3 2
4 1
5 3 2 2
So when this functions does its thing I get the combined sum of rows 1,2 and 5 = 55
Thnx in advance =)