Add Horizontal value with multiple vertical for specific value

[deepakverma]

Add Horizontal value with multiple vertical for specific value

I want to add multiple subtotal value to end total either sumif or hlookup with sum command


Sl. No. Item Code Location 100 KVA Ram Nagar SUB TOTAL 200 KVA Transport Nagar SUB TOTAL Total
1 M-0501081 No. 1 1 1 3.00 1 1 1 3.00 6.00