-
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.
sumproduct vlookup
-
B
Vlookup sumproduct?
Hello! I have managed to use the sumproduct formula in order to count the text "telefon" and "1/2 telefon" within a certain date...- Bonebeast
- Thread
- sumproduct vlookup
- Replies: 5
- Forum: Excel Questions
-
S
Multiple Criteria Look up Text result
So basically I am looking to build a formula that would take this information and return a text value. if it could work anything like this sumproduct formula to bring back text that would be awesome: <CODE>=SUMPRODUCT(--(A1:A10="7654321"),--(B1:B10="ABCDE"),--(C1:C10="3"),D1:D10) But instead...- skjolsc
- Thread
- index mulitple criteria sumproduct vlookup text vlookup
- Replies: 2
- Forum: Excel Questions
-
S
sumproduct/VLOOKUP with countif?
I am trying to do a count by text criteria for a particular date. The formula that that is currently in the spreadsheet is time consuming and user unfriendly and needs to have the range adjusted daily: =COUNTIF('Data-All-2012-13'!$G$2886:$G$2906,"NTH") <TBODY> Date NTH STH WEST 20/6/2013...- smandy
- Thread
- array countif sumproduct vlookup
- Replies: 6
- Forum: Excel Questions
-
L
sumproduct with vlookup
Hi all, I have the following formula that works perfectly.... =SUM(SUMPRODUCT(AP17:AQ22*AP16:AQ16)) However, when i try to lookup a value like so.... =SUM(SUMPRODUCT(O5:Q8*VLOOKUP(O3:Q3&"-"&O4:Q4,BK6:BN35,4,FALSE))) it doesn't work, even when I CSE the formula. I think i am batting along the...- lesbritten
- Thread
- sumproduct vlookup
- Replies: 3
- Forum: Excel Questions
