-
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.
relating
-
S
SumIf Function
Hi I am trying to have SumIf only sum values in column G that are >0. How do I incorporate the >0 into the following SumIf function (relating to column G) - =SUMIFS($G$4:$G$1000,$C$4:$C$1000,R12,$D$4:$D$1000,S12). Thanks- Steve 1962
- Thread
- column function incorporate relating sumif
- Replies: 3
- Forum: Excel Questions
-
Need help with DATE relating to a date of birth
Hello forum friends, need help with this formula as it is returning a result of 19919 if I enter a date of birth in 'personal information'!E5. I entered May 6, 1954 in 'personal information'!E5 hoping to see a result of 2019. =IF('personal information'!E5=0,"",'personal information'!E5+69)...- leopardhawk
- Thread
- birth date informatione5 personal relating
- Replies: 3
- Forum: Excel Questions
-
K
Unique data collection, if function
Hi, I want data relating to desired number in excel with any suitable formula. Ex: In sheet1, cell A95 has "121000". A96 "AA101", A97 "BX112", A98 "MN10" ect,. and A99 "1210001".now if i put formula in sheet2, i need Data relating the number "121000" in each cell by cell. and formula has to...- kishore k
- Thread
- cell data formula number relating
- Replies: 2
- Forum: Excel Questions
-
D
Vlookup a Date on another sheet
Hi I am having trouble extracting a value relating to a date in another worksheet. I am trying to lookup the value relating to 31/12/2010 as follows: <tbody> A B 31/12/2009 €6604 31/12/2010 €7784 31/12/2011 €8544 </tbody> I have tried a simple vlookup but to no avail Thanks- DavidMoran
- Thread
- 31/12/2010 date relating vlookup €6604
- Replies: 8
- Forum: Excel Questions
