|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 27th, 2004, 10:59 PM
|
|||
|
|||
sumif problem
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 to column B1 Appreciate your help Saziz --- Message posted from http://www.ExcelForum.com/ 
|
|
#2
July 27th, 2004, 11:05 PM
|
|||
|
|||
|
sumif problem
Hi
in B1 =IF(A11,A1,"") -- Regards Frank Kabel Frankfurt, Germany 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 to column B1 Appreciate your help Saziz --- Message posted from http://www.ExcelForum.com/
|
|
#3
July 27th, 2004, 11:36 PM
|
|||
|
|||
|
sumif problem
Frank Kabel wrote:
*Hi in B1 =IF(A11,A1,"") -- Regards Frank Kabel Frankfurt, Germany 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 to column B1 Appreciate your help Saziz --- Message posted from http://www.ExcelForum.com/ * Frank Thank you so much. Can you pls tell me what's wrong with this formula. =COUNTIF(S4,"-0")*SUMIF(S4,"0")*IF(S40,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 Saziz --- Message posted from http://www.ExcelForum.com/
|
|
#4
July 27th, 2004, 11:44 PM
|
|||
|
|||
|
sumif problem
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 S40 (in all other cases it should return an error). So please try to explain what your goal is :-) -- Regards Frank Kabel Frankfurt, Germany Frank Kabel wrote: *Hi in B1 =IF(A11,A1,"") -- Regards Frank Kabel Frankfurt, Germany 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 to column B1 Appreciate your help Saziz --- Message posted from http://www.ExcelForum.com/ * Frank Thank you so much. Can you pls tell me what's wrong with this formula. =COUNTIF(S4,"-0")*SUMIF(S4,"0")*IF(S40,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 Saziz --- Message posted from http://www.ExcelForum.com/
|
|
#5
July 28th, 2004, 12:05 AM
|
|||
|
|||
|
sumif problem
Frank Kabel wrote:
*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 S40 (in all other cases it should return an error). So please try to explain what your goal is :-) -- Regards Frank Kabel Frankfurt, Germany Frank Kabel wrote: *Hi in B1 =IF(A11,A1,"") -- Regards Frank Kabel Frankfurt, Germany 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 to column B1 Appreciate your help Saziz --- Message posted from http://www.ExcelForum.com/ * Frank Thank you so much. Can you pls tell me what's wrong with this formula. =COUNTIF(S4,"-0")*SUMIF(S4,"0")*IF(S40,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 Saziz --- Message posted from http://www.ExcelForum.com/ * Hi Frank, This is the sheet (pls see attached) Attachment filename: sample.xls Download attachment: http://www.excelforum.com/attachment.php?postid=630399 --- Message posted from http://www.ExcelForum.com/
|
|
#6
July 28th, 2004, 12:31 AM
|
|||
|
|||
|
sumif problem
Hi
in G2 enter: =IF(E3-F20,"",E3-F2) and copy down -- Regards Frank Kabel Frankfurt, Germany Frank Kabel wrote: *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 S40 (in all other cases it should return an error). So please try to explain what your goal is :-) -- Regards Frank Kabel Frankfurt, Germany Frank Kabel wrote: *Hi in B1 =IF(A11,A1,"") -- Regards Frank Kabel Frankfurt, Germany 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 to column B1 Appreciate your help Saziz --- Message posted from http://www.ExcelForum.com/ * Frank Thank you so much. Can you pls tell me what's wrong with this formula. =COUNTIF(S4,"-0")*SUMIF(S4,"0")*IF(S40,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 Saziz --- Message posted from http://www.ExcelForum.com/ * Hi Frank, This is the sheet (pls see attached) Attachment filename: sample.xls Download attachment: http://www.excelforum.com/attachment.php?postid=630399 --- Message posted from http://www.ExcelForum.com/
|
|
#7
July 28th, 2004, 12:46 AM
|
|||
|
|||
|
sumif problem
Frank Kabel wrote:
*Hi in G2 enter: =IF(E3-F20,"",E3-F2) and copy down -- Regards Frank Kabel Frankfurt, Germany Frank Kabel wrote: *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 S40 (in all other cases it should return an error). So please try to explain what your goal is :-) -- Regards Frank Kabel Frankfurt, Germany Frank Kabel wrote: *Hi in B1 =IF(A11,A1,"") -- Regards Frank Kabel Frankfurt, Germany 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 to column B1 Appreciate your help Saziz --- Message posted from http://www.ExcelForum.com/ * Frank Thank you so much. Can you pls tell me what's wrong with this formula. =COUNTIF(S4,"-0")*SUMIF(S4,"0")*IF(S40,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 Saziz --- Message posted from http://www.ExcelForum.com/ * Hi Frank, This is the sheet (pls see attached) Attachment filename: sample.xls Download attachment: http://www.excelforum.com/attachment.php?postid=630399 --- Message posted from http://www.ExcelForum.com/ * Frank Thank you so much. Now when its copied, since I am running a macro to do it, how can I tell it to copy untill there is data in target column, and stop if data ends. thanks Saziz --- Message posted from http://www.ExcelForum.com/
|
|
#8
July 28th, 2004, 05:00 PM
|
|||
|
|||
|
sumif problem
Hi Frank,
I would appreicate very much if you can help me on how to fill in the formula down upto the last cell containing data. Thank you for your help yesterday. Saziz --- Message posted from http://www.ExcelForum.com/
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Strange Problem Occured Using C#&Access | Xian Xu | General Discussion | 5 | June 30th, 2004 10:12 PM |
| PGP problem | Bob Henson | General Discussion | 0 | June 27th, 2004 11:28 AM |
| problem with an error | evil_one | General Discussion | 7 | June 17th, 2004 09:27 PM |
Linear Mode
