Dear All,

I'm trying to calculate amount over the criteria, as per range ("L1:M5").

The desired solution in Col O per person. Created Helper Column in Col J but it's limited to

one Sales Agent i.e Apple.

I was wondering, if the calculation in col J was possible, without a Helper Column in Col J.

My formula in cell N2 is not generating the correct result.

<html><head><title>Excel Jeanie HTML</title></head>******>

<!-- ######### Start Created Html Code To Copy ########## -->

<!-- ######### End Created Html Code To Copy ########## -->

</body></html>

Your help would be greatly appreciated. Hoping for a formula solution without a helper column. I believe sumproducts maybe be useful to desire the solution based on multiple criterias.

Kind Regards

Biz

I'm trying to calculate amount over the criteria, as per range ("L1:M5").

The desired solution in Col O per person. Created Helper Column in Col J but it's limited to

one Sales Agent i.e Apple.

I was wondering, if the calculation in col J was possible, without a Helper Column in Col J.

My formula in cell N2 is not generating the correct result.

<html><head><title>Excel Jeanie HTML</title></head>******>

<!-- ######### Start Created Html Code To Copy ########## -->

<!-- ######### End Created Html Code To Copy ########## -->

</body></html>

Your help would be greatly appreciated. Hoping for a formula solution without a helper column. I believe sumproducts maybe be useful to desire the solution based on multiple criterias.

Kind Regards

Biz

Last edited: