Commission Status

[jeo varghese]

Dear all,
Please find the attached excel file, in that commission status get result with yes or no answer in my exported raw data sheet, how can i apply formula to get result of separated by commission amount and non commission amount from an invoice total amount ?
With regards
Jeo

 

[kchiba]

Look at the uploaded file

 

[jeo varghese]

dear all


My excel shows error "Run time error '1004'. This extension cannot be used with selected file type and so on..

please suggest any solution for this issue ?

jeo

 

[Somendra Misra]

Hi Jeo,

What is the file extension and on what version you are trying to open the file?

Regards,

 

[Faseeh]

Hi Jeo,

Please this: if you want to sum items to be commisioned use:

=SUMPRODUCT((B4:B7=123)*(E4:E7="Yes")*(D4:D7*H4:H7))

This will show total of the individual omissions.

If you want individual comission then put in F4 this and drag down:

=IF(E4="Yes",H4*D4,0)