Windows XP Ignore 0s using Min/Max/Avg Functions across multiple spreadsheets

F

fkurilla

Joined
Jan 3, 2007
Messages
4
Reaction score
0
Does anyone know the syntax for a formula to return the minimum value of an array of numbers in multiple spreadsheets when the numbers are negative, while ignoring any 0 values?

Would also like to know how that syntax would change to return the maximum value and the average value with the same parameters above.

Any help anyone can provide is greatly appreciated.

Cheers!

Frank
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to find additional ranges outside of min, max, and average 2
ignore MAX and MIN values in a set to calculate average 5
MAX / MIN function problem 4
Macro to select MIN MAX from selection 3
Custom or VBA Function for Avg, Std, Min, Max 1
ScrollBar - set MIN/MAX cell value 2
nesting functions to compare segments of two columns 1
getting the min and max of a list of numbers 9

Top