Hello...
One more time I need help to...
Joined this 2 or 3 forms.
=SE(B12="";"";PROCV(B12;Base!$A$2:$Z$100;6;FALSE))
=SE(SOMA(CONTAR.SE(D12:AH12;"OS");D12:AH12;"SS"));"143";"144";"---")
Hello...
One more time I need help to...
Joined this 2 or 3 forms.
=SE(B12="";"";PROCV(B12;Base!$A$2:$Z$100;6;FALSE))
=SE(SOMA(CONTAR.SE(D12:AH12;"OS");D12:AH12;"SS"));"143";"144";"---")
Last edited by Birnen; 08-12-2010 at 01:29 PM.
Hi, Birnen,
I'll move your post to Non English Excel
hi, arthurbr;
In that case, I will be helped in the Sec. XXII...
I allready post in English with this Non English Excel... and be helped...
If I am right =SE(SOMA(CONTAR.SE(D12:AH12;"OS");D12:AH12;"SS"));"143";"144";"---") is an IF function. The result of which contains 3 values (143,144,---)instead of 2
What does the part starting with SOMA ( sum) do ?
hi...
is to sum the times we write, OS,SS...
And that about the...
=SE(B12="";"";PROCV(B12;Base!$A$2:$Z$100;6;FALSE))
To find a specify number in the base sheet.
If B12 is P, C12 will be 144 but, 144 only apper's if D12:AH12 content OS, SS...
Just one more thing, I will work whit many letter's (OS, SS, AT,...) and the values are just 3 (like you have see, 143,144,---)
Last edited by Birnen; 08-12-2010 at 05:44 AM.
I think a sample workbook would help. I can understand what the functions are, but not what you are expecting them to do in this combination.
Remember what the dormouse said
Feed your head
I noticed there was a problem in the col_index_num: In Folha2, E2 and F2 had the same col_index_num referring to 2 which I believe is wrong. The col_index_num should be equal to 2 in E2 and col_index_num should be equal to 3 in F2. Then you can drag down the formula.
Now do you still need to combine the formulas mentioned above? And if Yes, in what cell should the formula be?
If I helped, Don't forget to add to my reputation (click on the little scale)
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
Disregard the first file I sent you, use the one I am attaching right now.
You can input this formula in Folha2 Range E2:
you can drag down the formulaPlease Login or Register to view this content.
And put this formula in Folha2 Range F2:
you can drag down the formulaPlease Login or Register to view this content.
I included a "Yes" argument to the formula. Let me know if you need anything else
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks