sumif problem

[saziz]

Hi Guys,
I am using SUMIF(B1,"<0") to find out negative values in column A1.
Now how can I say if the value in column A1is >1 bring that value t
column B1
Appreciate your help
Sazi

 

[Frank Kabel]

Hi
in B1
=IF(A1>1,A1,"")

 

[saziz]

*Hi
in B1
=IF(A1>1,A1,"")

Frank Thank you so much. Can you pls tell me what's wrong with thi
formula.

=COUNTIF(S4,"<-0")*SUMIF(S4,"<0")*IF(S4>0,S4,"")
I am checking time values in S4, the format is something like this:
0:14(minutes)
If I put this in R4 its reducing the value of S4 to 0:0
What's wrong here.
Thanks for your help
Sazi

 

[Frank Kabel]

Hi
what are you trying to achieve with this formula. Note: In most cases
SUMIF/COUNTIF are used on a range of cells and NOT on a single cell.
for this use IF statements.

Your formula will return zero in all cases in which S4>0 (in all other
cases it should return an error). So please try to explain what your
goal is

 

[saziz]

*Hi
what are you trying to achieve with this formula. Note: In mos
cases
SUMIF/COUNTIF are used on a range of cells and NOT on a single cell.
for this use IF statements.

Your formula will return zero in all cases in which S4>0 (in al
other
cases it should return an error). So please try to explain what your
goal is


--
Regards
Frank Kabel
Frankfurt, Germany


Hi Frank,
This is the sheet (pls see attached

Attachment filename: sample.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=63039

 

[Frank Kabel]

Hi
in G2 enter:
=IF(E3-F2<0,"",E3-F2)
and copy down

--
Regards
Frank Kabel
Frankfurt, Germany

 

[saziz]

*Hi
in G2 enter:
=IF(E3-F2<0,"",E3-F2)
and copy down

Frank Thank you so much. Now when its copied, since I am running
macro to do it, how can I tell it to copy untill there is data i
target column, and stop if data ends.
thanks
Sazi

 

[saziz]

Hi Frank,
I would appreicate very much if you can help me on how to fill in th
formula down upto the last cell containing data.
Thank you for your help yesterday.
Sazi