is it possible for Vlookup and CountIf function in the same forumla?
 

I really really really need help on this one...in my excel sheet, I
have to sheets, one is called Data and the other is extract. In the
"data" sheet, I have about 764 lines in Column D with store numbers,
in the "extract" sheet, I have up to 19165 rows of data. These data
contains the stores in the "data"sheet, which shows a list of lines
that the stores has done planning for, this is identified by the
forumala =IF(I10=J10,"Unreviewed","Reviewed"). Each store has around
1000 lines. What I need to know is can I do a vlookup in the "Data"
sheet where it will look up in "extract" and count the total number of
lines "Unreviewed" and display next to the store numbers in the "data"
sheet....I hope i make sense...please help me...thanks

is it possible for Vlookup and CountIf function in the same foruml
 

try:

=SUMPRODUCT(--(Data!$A$2:$A$19165=D2),--(Data!$C$2:$C$19165="Unreviewed"))

Column A of Data contains Store ID and C contains "Unreviewed"

D2 (in Extract) is Store ID

Copy formula down.

"Gor_yee" wrote:

I really really really need help on this one...in my excel sheet, I
have to sheets, one is called Data and the other is extract. In the
"data" sheet, I have about 764 lines in Column D with store numbers,
in the "extract" sheet, I have up to 19165 rows of data. These data
contains the stores in the "data"sheet, which shows a list of lines
that the stores has done planning for, this is identified by the
forumala =IF(I10=J10,"Unreviewed","Reviewed"). Each store has around
1000 lines. What I need to know is can I do a vlookup in the "Data"
sheet where it will look up in "extract" and count the total number of
lines "Unreviewed" and display next to the store numbers in the "data"
sheet....I hope i make sense...please help me...thanks