Thread: Forumla Error
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tim m tim m is offline
external usenet poster
 
Posts: 430
Default Forumla Error

You want the result from the formula that is in the page called weekly data?
or you want the formula in your current sheet but to look up the data in
Weekly Data?

Perhaps this is what you want?
=COUNTIF(Weekly Data!A1:A5,"W*")

"Killer" wrote:

Trying add formula reading data from another page called "Weekly Data"

=COUNTIF(M2:M256,"W*")

"tim m" wrote:

What are you trying to accomplish? Can't quite see where the VLOOKUP fits in
there.

"Killer" wrote:

Can't seem to get this code to work correctly...

=VLOOKUP(Weekly Data'! COUNTIF(M2:M256,"W*")

Any help would be appreciated.

Rob