Solved

# Help w/ formulas not working

Posted on 2012-08-14
Medium Priority
329 Views
Hi,

I'll do my best to make this easy to understand.

On the "Productivity Dashboard" page, I have Audrey and Katherine. I want to count all blank cells tied to their name on the "Raw Data" page during a particular date range. (C6 and C7).

Also, my Vlookup (F4) doesn't seem to me working for Zack--but it works for all the other people.

Thanks
SSTempEE.xlsm
0
Question by:nomios

LVL 19

Expert Comment

ID: 38292510
for cells C6 you could use the formula
``````=COUNTIFS('Raw Data'!A:A, 'Productivity DashBoard'!B6, 'Raw Data'!V:V, "")
``````
C7 would be the same but with !B7 instead of !B6.
0

LVL 39

Assisted Solution

nutsch earned 1000 total points
ID: 38292516
Try this for Audrey:

=COUNTIFS('Raw Data'!\$V:\$V,'Productivity DashBoard'!\$B\$1,'Raw Data'!\$A:\$A,B6,'Raw Data'!I:I,"")
0

LVL 13

Accepted Solution

Shanan212 earned 1000 total points
ID: 38292520
The Vlookup formula should be

=VLOOKUP(B4,'NonProductive Time'!\$A\$1:\$M\$7,'Productivity DashBoard'!\$G\$1,FALSE)

Then drag it down (you were missing the 'False' at the end)
0

LVL 19

Expert Comment

ID: 38292525
The vlookup problems seem to be related to dragging the formulae up & down:

F5: =VLOOKUP(\$B5,'NonProductive Time'!A2:M8,\$G\$1)
F8: =VLOOKUP(\$B8,'NonProductive Time'!A5:M11,\$G\$1)
F9: =VLOOKUP(\$B9,'NonProductive Time'!A6:M12,\$G\$1)

this should have been

F4: =VLOOKUP(\$B4,'NonProductive Time'!A\$2:M\$8,\$G\$1)
F5: =VLOOKUP(\$B5,'NonProductive Time'!A\$2:M\$8,\$G\$1)
F8: =VLOOKUP(\$B8,'NonProductive Time'!A\$2:M\$8,\$G\$1)
F9: =VLOOKUP(\$B9,'NonProductive Time'!A\$2:M\$8,\$G\$1)
0

LVL 39

Expert Comment

ID: 38292529
Agreed with Shanan212 for the vlookup (though I find it faster to put 0 instead of false). Make sure you also put \$ around your references so they don't shift when you drag them down.

Thomas
0

Author Closing Comment

ID: 38292845
Thank you so much
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a serious pitfall that can happen when deleting shapes using VBA.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
###### Suggested Courses
Course of the Month13 days, 20 hours left to enroll