sumif problem

S

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
 
S

saziz

Frank said:
*Hi
in B1
=IF(A1>1,A1,"")
Click to expand...

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
 
F

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 :)
 
S

saziz

Frank said:
*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
Click to expand...
 
F

Frank Kabel

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

--
Regards
Frank Kabel
Frankfurt, Germany

 
S

saziz

Frank said:
*Hi
in G2 enter:
=IF(E3-F2<0,"",E3-F2)
and copy down
Click to expand...
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
 
S

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
 
Top