autosum, ignore certain conditions.

  • Thread starter Thread starter n00batW0rk
  • Start date Start date
N

n00batW0rk

how can i get autosum to ignore certain conditions?

a1: 5
a2: 6
a3: 3
a4: 7


I want to do an autosum but not count anything less than 5
 
Hi,
Not sure about Autosum, but you could use an array entered formula:
assuming data in A1:A4,
{=sum(if(A1:A4<5,FALSE,A1:A4))} to give the result 18
Remember the curly braces are not entered manually, but the formula is entered by ctrl-shift-enter
Mathew




how can i get autosum to ignore certain conditions?

a1: 5
a2: 6
a3: 3
a4: 7


I want to do an autosum but not count anything less than 5.
 
Back
Top