asyamonique
Well-known Member
- Joined
- Jan 29, 2008
- Messages
- 1,280
- Office Version
- 2013
- Platform
- Windows
Hello,
How can I change the sum ranges with given formula below?
Its lıke I wanna calculate all row instead of a column.
Apple= 45
Many Thanks
How can I change the sum ranges with given formula below?
Its lıke I wanna calculate all row instead of a column.
Apple | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |
Apple= 45
Many Thanks
Excel Formula:
=SUMIF(A:J,K2,B:B)