-
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.
telling
-
B
Sumifs + match formula
<tbody> I am able to get the below to return the correct values but I need it to do a match instead of me telling which row to look at =SUMIFS('Item Types ST Weekly'!$D7:$BD7,'Item Types ST Weekly'!$D$2:$BD$2,">="&$D7,'Item Types ST Weekly'!$D$2:$BD$2,"<="&$E7) ** MATCH($C7,'Item Types...- brandybartz
- Thread
- match row sumifs telling types
- Replies: 1
- Forum: Excel Questions
-
F
IF ISNA Workings
Hi I want that frustrating #N/A message not to show when I do a vlookup. I've attched my formula, what am I doing wrong? IF(ISNA(VLOOKUP(A5;'Naasif List'!$A$3:$T$237;4;FALSE);0;VLOOKUP(A5;'Naasif List'!$A$3:$T$237;4;FALSE) Keep's telling me I have to many arguments in formula. <strike></strike>- Ferengi
- Thread
- arguments formula ifisnavlookupa5;naasif telling wrong
- Replies: 3
- Forum: Excel Questions
-
M
Help with IF
Hi, :) I am trying to make a nested IF/SUM formulas that increases in tiers and gets 100 times slower to increase each tier. I want the formula to react to the value of one other number (in this case cell J19). I am using Excel 2010. This is my current formula but Excel is telling me "you've...- mag47
- Thread
- excel formula function number telling
- Replies: 2
- Forum: Excel Questions
