greater than zero

  1. A

    How to do Sumproduct function with only values greater than zero

    Hi, so my problem is fairly simple im just struggling to get the right result. My data is effectively something like this <tbody> A B 5 8 2 10 0 9 0 2 11 6 </tbody> What i want to do is do a sumproduct of the two columns for only the rows when A is greater than zero, (i.e. only...
  2. David1976

    Lookup Next Available Date

    Hello, I'm sure this should be very simple but I can't seem to make it work. I've tried a few vlookups & index/matches but can't get it right. I need to scan down column K to find the first value greater than zero, then return the value in that row from column B. When I try vlookup, it seems to...
  3. D

    Array formula with minimum value greater than 0 and an additional condition

    Hi All, I've been trying for a little while now through research and I'm finally stumped. My excel needs have usually always been solved through searching, learning and then modifying what I've found, not this time. :confused: Let's say that I have 3 columns. Column A is called range1 and...
  4. J

    Average Value Greater Than Zero with AVERAGEIFS

    Hello, I am trying to figure out a way to average only values that are greater than zero. Right now 99% of my reports work with an AVERAGEIFS formula as shown below but there are some cases where 0% gets pulled into the equation. In my summary table (K thru T) I want to average only % that...
    • jws
    • Thread
    • averageifs exclude zero value greater than zero
    • Replies: 4
    • Forum: Excel Questions

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top