-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
if(countif
-
B
IF Statements & Formulas Don't Work In This Case, That I Can Find.
I have three (3) types of apples in three equal size buckets. - Eatable, Bankable, and Borrowable. I can eat the apples in the buckets but only the contents of one bucket per day. I can bank the apples in the buckets if I don’t want to eat any each day. If I don’t eat them or bank them I lose...- bonrea
- Thread
- if(countif
- Replies: 5
- Forum: Excel Questions
-
E
Trouble combining If(Countif & Vlookup criteria to omit 1/0/1900 values
Hello. I am using Windows 7 and Excel 2007. I want to see results if the alpha-numeric value of column B appears in column A of Sheet3. The result I am looking for is a date value from Sheet3 listed in column W corresponding to the row matching the value in the current sheet's column B. If...- eNovice22
- Thread
- 1/0/1900 countif and excel formula if(countif if(len(vlookup vlookup 2 conditions
- Replies: 3
- Forum: Excel Questions
-
F
How to return multiple instances of data from multiple worksheets
I have data in multiple worksheets in which each row has a cell that tells the 'destination' for the supplies in that row. The row also includes unit cost, quantity and total cost. I want to be able to pull all rows across all worksheets that have have the same 'destination' into a new...- fzeke150
- Thread
- if(countif
- Replies: 2
- Forum: Excel Questions
