These are the symbols and formulas to use that are equivalent to calculator. Cell J6 is =SUM(J2:J3) and drag to right untill O6.Īnyways, probably there are a lot of ways doing this. This is how to add, subtract, multiply and divide in Excel and Google Sheets. It should now be A1A2, press enter to see what happens.
Rest of columns are formulas.Ĭell K2 got this formula: =VLOOKUP($I2,$A$2:$E$4,MATCH(K$1,$A$1:$E$1,0) FALSE)*$J2ĭrag to right this formula untill cell N2 and then drag down (in my example is just 2 rows).įormula in cell O2 is =SUM(J2:N2) just drag down too.įinally, the grand totals row is just another summatory of everything above. Lets change from addition to multiplication, by replacing the (+) with a (). The right side needs manual input only in columns I (Pallet type) and J (quantity of pallets). The left side is source data so everything is manual input. You just input what type of pallet you want and how many and everything will be calculated. Use SUMPRODUCT() SUMPRODUCT(C2:C14-B2:B14) This will subtract each row and sum the resultants for rows 2 through 14. This example allows you to manage different types of pallets (let's say pallet A can hold only 1 apple, but pallet C can hold 9 apples) and calculate everything on the right side. As I said in my comment, the question is unclear but this is just and example of how you could store your data and then, depending on how many pallets you choose, calculate subtotals and grandtotals for each fruit:
0 kommentar(er)
