| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
mark and skip a specific row
Hello! can anyone help me with my problem: i have a formula that searches in
a worksheet a value, but that value is on two or more rows. how can i sum those values? Can anyone help me please! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
mark and skip a specific row
Maybe use =sumif()???
Hasty wrote: Hello! can anyone help me with my problem: i have a formula that searches in a worksheet a value, but that value is on two or more rows. how can i sum those values? Can anyone help me please! -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
mark and skip a specific row
ok. but my formula allways searches for the first record that maches my
criteria. how can i make it go to the second record that maches my criteria? this is the formula that i used: =VALUE(IF(ISERROR(TRIM(IF(AND($I$1<"",$F6<""),IF (AND($F6<"",$B6<""),INDEX(T_BAZA2,MATCH(CFC2,C_C OMPLET2,0),14),""),""))),"",TRIM(IF(AND($I$1<"",$ F6<""),IF(AND($F6<"",$B6<""),INDEX(T_BAZA2,MATC H(CFC2,C_COMPLET2,0),14),""),"")))) Thank You and please help |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
mark and skip a specific row
Based on your question, I think you require a SUMPRODUCT formula
-- Robert |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
mark and skip a specific row
is there a different way, with a macro maybe, because this does not work
"Robert" wrote: Based on your question, I think you require a SUMPRODUCT formula -- Robert |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
mark and skip a specific row
Maybe you could use the technique that Chip Pearson shows for the arbitrary
lookup: http://www.cpearson.com/excel/lookups.htm Hasty wrote: ok. but my formula allways searches for the first record that maches my criteria. how can i make it go to the second record that maches my criteria? this is the formula that i used: =VALUE(IF(ISERROR(TRIM(IF(AND($I$1<"",$F6<""),IF (AND($F6<"",$B6<""),INDEX(T_BAZA2,MATCH(CFC2,C_C OMPLET2,0),14),""),""))),"",TRIM(IF(AND($I$1<"",$ F6<""),IF(AND($F6<"",$B6<""),INDEX(T_BAZA2,MATC H(CFC2,C_COMPLET2,0),14),""),"")))) Thank You and please help -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
mark and skip a specific row
Ps. If you don't get a good answer here, try posting your question with the
formula in the .worksheet.functions newsgroups. Those people over there are very smart and eat these things for breakfast! Dave Peterson wrote: Maybe you could use the technique that Chip Pearson shows for the arbitrary lookup: http://www.cpearson.com/excel/lookups.htm Hasty wrote: ok. but my formula allways searches for the first record that maches my criteria. how can i make it go to the second record that maches my criteria? this is the formula that i used: =VALUE(IF(ISERROR(TRIM(IF(AND($I$1<"",$F6<""),IF (AND($F6<"",$B6<""),INDEX(T_BAZA2,MATCH(CFC2,C_C OMPLET2,0),14),""),""))),"",TRIM(IF(AND($I$1<"",$ F6<""),IF(AND($F6<"",$B6<""),INDEX(T_BAZA2,MATC H(CFC2,C_COMPLET2,0),14),""),"")))) Thank You and please help -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| mark up | Excel Worksheet Functions | |||
| Foot mark aka single quote mark? | Excel Worksheet Functions | |||
| How can I add active tick mark/check mark boxes in excel? | Excel Discussion (Misc queries) | |||
| using IF to skip | Excel Worksheet Functions | |||
| How can I calculate dates and skip a specific weekday? | Excel Discussion (Misc queries) | |||
Hybrid Mode
