John Sadler
New Member
- Joined
- May 1, 2012
- Messages
- 48
Hi folks,
Looking for a dynamic sort of formula that will Sum B5 in every sheet where A5 = Internal.
So there may be 20 sheets but only 3 are currently Internal but this number will increase and I don't want to manually have to update it.
I can visualise this in VBA but not a formula
Cheers folks
John
Looking for a dynamic sort of formula that will Sum B5 in every sheet where A5 = Internal.
So there may be 20 sheets but only 3 are currently Internal but this number will increase and I don't want to manually have to update it.
I can visualise this in VBA but not a formula
Cheers folks
John