Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Write a single excel VBA function that performs the sum as shown in the screenshots below. T14 fx Name Box 3 C D E F
Write a single excel VBA function that performs the sum as shown in the screenshots below.
T14 fx Name Box 3 C D E F G H J K L M N 0 P Q R 1 2 3 Mar-19 Jun-19 Sep-19 Dec-19 Mar-20 Jun-20 Sep-20 Dec-20 Mar-21 Jun-21 1 1 1 1 1 1 1 1 Sep-21 Dec-21 1 1 Mar-19 - 11 NP 4 2 2 W NP w NP 2 2 2 2 30 nm 5 3 3 3 3 3 3 54 Jun-19 Sep-19 Dec-19 Mar-20 6 4 4 4 4 4 4 4 4 80 7 - 5 5 5 5 5 5 5 105 8 Jun-20 6 6 6 6 6 6 126 - 7 7 7 7 7 140 8 8 8 8 144 9 10 11 12 - 9 9 9 135 Sep-20 Dec-20 Mar-21 Jun-21 Sep-21 Dec-21 - - 10 10 110 13 11 66 14 - - - - - - 15 1 1 1 1 1 1 1 1 1 1 2 W NP 2 2 2 2 2 2 2 2 3 3 3 3 3 3 4 3 4 3 4 3 4 4 4 4 4 4 5 5 5 5 5 5 5 - 6 6 6 6 6 6 =SUM(F3:P3) =SUM(G3:P4) =SUM(H3:P5) =SUM(13:P6) =SUM(13:P7) =SUM(K3:P8) =SUM(L3:P9) =SUM(M3:P10) =SUM(N3:P11) =SUM(03:P12) =SUM(P3:P13) - 7 7 7 7 7 8 8 8 000 - - - 9 9 10 10 11 - - - - - - - T14 fx Name Box 3 C D E F G H J K L M N 0 P Q R 1 2 3 Mar-19 Jun-19 Sep-19 Dec-19 Mar-20 Jun-20 Sep-20 Dec-20 Mar-21 Jun-21 1 1 1 1 1 1 1 1 Sep-21 Dec-21 1 1 Mar-19 - 11 NP 4 2 2 W NP w NP 2 2 2 2 30 nm 5 3 3 3 3 3 3 54 Jun-19 Sep-19 Dec-19 Mar-20 6 4 4 4 4 4 4 4 4 80 7 - 5 5 5 5 5 5 5 105 8 Jun-20 6 6 6 6 6 6 126 - 7 7 7 7 7 140 8 8 8 8 144 9 10 11 12 - 9 9 9 135 Sep-20 Dec-20 Mar-21 Jun-21 Sep-21 Dec-21 - - 10 10 110 13 11 66 14 - - - - - - 15 1 1 1 1 1 1 1 1 1 1 2 W NP 2 2 2 2 2 2 2 2 3 3 3 3 3 3 4 3 4 3 4 3 4 4 4 4 4 4 5 5 5 5 5 5 5 - 6 6 6 6 6 6 =SUM(F3:P3) =SUM(G3:P4) =SUM(H3:P5) =SUM(13:P6) =SUM(13:P7) =SUM(K3:P8) =SUM(L3:P9) =SUM(M3:P10) =SUM(N3:P11) =SUM(03:P12) =SUM(P3:P13) - 7 7 7 7 7 8 8 8 000 - - - 9 9 10 10 11Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started