Prev: Excel Shared Over Internet
Next: Vlookup with sums
From: Sheeloo on 18 Apr 2010 11:46
Hello Mama,

It is nice to see, after a long time, me, you, David and Biff responding to
the same post...

Vijay might have a <2 or <11 in his data...

"Teethless mama" wrote:

> =SUMPRODUCT(--(SUBSTITUTE(A1:A3,"<1",1)))
>
>
> "Vijay Dhawan" wrote:
>
> > Hi,
> >
> > How can I sum the numbers in a column in Excel where some numbers carry a
> > "<" sign in front of them (such as <1) and I want to include numbers such
> > "<1" in calculation as "1".
> >
> > For Example if numbers are entered as follows
> >
> > 0.5
> > <1
> > 0.5
> >
> > I would like to value to be returned as "2" when I apply "sum" function.
> >
> > Thanks
> >
First  |  Prev  | 
Pages: 1 2
Prev: Excel Shared Over Internet
Next: Vlookup with sums