Here are some problems that our users have asked and received explanations on
have two product use lists and I want to be able to count/sum the adjacent cell numbers to get a total product used.
product # | # of products product # | # of products
want to sum the (# of products) by the (product #)
Solved by C. J. in 12 mins
I need help with a sum product formula tht
Solved by Z. U. in 23 mins
I'm using excel for financial analysis, and I want to sum numbers of the 2nd largest product. The product numbers, where I would calculate if it was the 2nd largest, are different than the numbers I want to sum. Any ideas?
Solved by O. B. in 24 mins
I need to write a formula for Excel this is
Total cost of product revenue (D18)
Divided by the amount of units (H18)
-Giving me cost per product
Minus cost to make product (MMCOST!B10)
- Giving me cost per product after costs
Then times this by the number of units (H18)
we have tried
=H18*((D18/H18))-MMCOST!B10
but this is not working
basic calculation on a calculator is
1022/146 =
-2.12
x146
Thanks Rob
Solved by C. Y. in 15 mins
I need help writing a formula using sum product for weighted average