10 ways to sum in Excel

10 ways to sum in Excel using sample data in table format:

1. Using the SUM function:
   

   	A
   1	10
   2	20
   3	30
   4	40
   5	50
   =SUM(A1:A5) will return 150

2. Using AutoSum: Select the cells A1:A5, then click the AutoSum button in the Home tab of the ribbon. It will automatically insert the formula =SUM(A1:A5)
3. Using a formula:
   

   	A
   1	10
   2	20
   3	30
   =A1 + A2 + A3 will return 60

4. Using the SUMIF function:
   

   	A	B
   1	10	100
   2	20	200
   3	30	300
   4	40	400
   5	50	500
   =SUMIF(A1:A5,”>20″,B1:B5) will return 1200

5. Using the SUMIFS function:
   

   	A	B	C
   1	10	100	5
   2	20	200	10
   3	30	300	15
   4	40	400	20
   5	50	500	25
   =SUMIFS(B1:B5,A1:A5,”>20″,C1:C5,”<15″) will return 700

6. Using the SUMPRODUCT function:
   

   	A	B
   1	2	1
   2	3	2
   3	4	3
   4	5	4
   5	6	5
   =SUMPRODUCT(A1:A5,B1:B5) will return 70

7. Using the SUMIF with multiple criteria:
   

   	A	B
   1	10	100
   2	20	200
   3	30	300
   4	40	400
   5	50	500
   =SUMIFS(B1:B5,A1:A5,”>20″,A1:A5,”<40″) will return 700

8. Using the SUMIF with OR logic:
   

   	A	B
   1	10	100
   2	20	200
   3	30	300
   4	40	400
   5	50	500
   =SUMIFS(B1:B5,A1:A5,”>20″,A1:A

Sure, here are some additional examples of ways to sum in Excel using sample data:

9. Using the SUMIF with AND logic:
   

   	A	B	C
   1	10	100	5
   2	20	200	10
   3	30	300	15
   4	40	400	20
   5	50	500	25
   =SUMIFS(B1:B5,A1:A5,”>20″,C1:C5,”<15″,C1:C5,”>10″) will return 300

10. Using the SUMIF with a range and criteria in separate cells: | | A | B | C | |—|—|—-|—-| | 1 | 10 | 100 | 5 | | 2 | 20 | 200 | 10 | | 3 | 30 | 300 | 15 | | 4 | 40 | 400 | 20 | | 5 | 50 | 500 | 25 | In cell D1, enter the criteria “>20” In cell D2, enter the range “A1:A5” In cell D3, enter the range “B1:B5” In cell D4, enter the formula “=SUMIF(D2,D1,D3)” This will return the sum of the values in range B1:B5 where the corresponding values in range A1:A5 are greater than 20

Please note that these examples are based on a simple data set and may not reflect the best practices for using these functions in more complex scenarios.