I have a complicated problem. I have a list with 10 columns and xxxxx rows.
All I want to do is (i attached a sample xls)
There is a value in Sheet2!A1 which I want to lookup in Sheet1 (A:J) and find out how many A1,A2,A3... is associated with the given value.
default2.xlsx
I've tried countif(vlookup(vlookup) ctrl+shift+enter but it didn't work.
Sheet2!A1 has no value! Which is the value?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Sorry. I updated it.
default2.xlsx
In B2 and copy to the right
=SUMPRODUCT((Sheet1!$A$2:$A$42=$A1)*(Sheet1!$J$2:$J$42=B$1))
You are welcome!
Thanks for the reb*
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks