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
Post a Comment