# Sumproduct question

#### ASpannTx

##### New Member
Thanks to your wonderful site I was able to solve half my formula problem

I have the following formula:

=SUMPRODUCT((C4:C304=701)*(L4:L304>=0.01))

But I need it to also look at M4:M304 and N4:N304 and if L,M OR N are >=0.01 count but sometime there might be a value in L M and N but i only want it to count once for that row.

Thanks in advance for any help.

### Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

#### Dave Patton

##### Well-known Member
Welcome to the forum

try

=SUMPRODUCT(--((L4:L304>=0.01)+(M4:M304>=0.01)+(N4:N304>=0.01)>0)*(C4:C304=701))

#### ASpannTx

##### New Member
That did exactly what I wanted it to do, perfect... Thanks a million!

#### Dave Patton

##### Well-known Member
Thanks for the feedback.

#### ASpannTx

##### New Member

Most definitely, I am so excited that it works... although I really don't understand the why behind it... if you don't mind, can you explain in layman terms the logic? If not, I am okay with Just the fact that it works.

#### Dave Patton

##### Well-known Member
We can evaluate a formula with Tools | Formula Auditing | Evaluate (Alt tuf) or use the icon (Evaluate Formula). You may have to add the the evaluate icon to your menu of icons.

With the above, we can visually step through the calculation. It is a good idea to work with a very concise example so we can focus on the particular challenge; it also makes it easier to follow the "Evaluation".

This helps us understand the formula and/or to troubleshoot it.

You can also search the forum for many examples and explanations.

Mr. Aladin Akyurek in particular plus others contributed greatly to the knowledge base re SumProduct.

Last edited:

#### ASpannTx

##### New Member

Thanks again, you saved me alot of time fighting with it... Many, many thanks

#### ASpannTx

##### New Member
Thanks for the additional information, it helped me understand the function a little better. Thanks again to both of you for your assistance. It is much appreciated.

#### shemayisroel

##### Well-known Member
Thanks for the additional information, it helped me understand the function a little better. Thanks again to both of you for your assistance. It is much appreciated.

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,164,147
Messages
5,835,669
Members
430,373
Latest member
swartzfeger

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back