formula in excel

caprashantarya 

You can use the SUMIF function to sum a column up to a specific amount. Here are the steps:

1. Click on the cell in your table where you want to see the total of the selected cells.
2. Enter =SUMIF( to this selected cell.
3. Now select the range with the numbers you want to total and press Enter on your keyboard.
4. Enter the criteria for the sum in the next argument. For example, if you want to sum up to 100, enter "<100" in the next argument.

------------------------------------------------------------------

1. If you want to use the RANDBETWEEN function to generate random numbers in a specific column, you can use the SUM function to total the column. Here are the steps:
1. Click on the cell in your table where you want to see the total of the selected cells.
2. Enter =SUM( to this selected cell.
3. Now select the range with the numbers you want to total and press Enter on your keyboard.

This will give you the total of the column with the random numbers generated by the RANDBETWEEN function.

I hope this helps! 

🙂