siddharth_kale
New Member
- Joined
- Dec 29, 2010
- Messages
- 24
Hi,
I want to use the below formula with range of cells (D1:L1) from different sheets:
=SUMPRODUCT(SUMIF(A1:A7,D1:L1,B1:B7))
Could you let me know how this can be done?
Regards,
Siddharth
I want to use the below formula with range of cells (D1:L1) from different sheets:
=SUMPRODUCT(SUMIF(A1:A7,D1:L1,B1:B7))
Could you let me know how this can be done?
Regards,
Siddharth