excel - Adding division to current formula -


i have excel formula found below this:

scenario:

i have 3 products, product a, product b , product c. want able calculate actual revenue. data structure in image. top-most row month. each month have 4 columns, of 2 need calculated should condition match.

this condition. example, product a, calculate total sumproduct (multiplies column actual customers x price actuals) yearmonth 201501.

so basically, first, product a, need find yearmonth 201501, , when found, should find columns actual customers , price actuals , return sumproduct of actual customers , price actuals.

modification help

i want formula divide @ end total amount of customers specific product , month. how can that?

here workbook. workbook

=sumproduct($b$3:$i$5*($b$1:$i$1=themonth)*(($b$2:$i$2="actual customers")+($b$2:$i$2="price - actuals"))*($a$3:$a$5=theproduct)) 

if need amount of customers month , product, can modify sumproduct function this:

=sumproduct($b$3:$i$5*($b$1:$i$1=themonth)*(($b$2:$i$2="actual customers")*($a$3:$a$5=theproduct))) 

that (for me) returned value 56 p c , 1951 p b, i'm pretty sure have formula1/formula2 want (where formula1 original formula , formula2 1 posted here.


Comments