Vlookup + sumif , but how???? - microsoft.public.excel.worksheet.functions

this is my database (ROW and column A52 IS description) A B C D E F G description data b data c name tot tot a totb purple 1 1 qq 12000 0 12000.0 yellow 1 1 ww 630 0 630.0 blue 1 1 ee 1341 0 1341.0 orange 1 1 rr 17548 0 17548.0 black 1 1 tt 228 0 228.0 purple 1 1 yy 131 0 131.0 black 1 1 uu 27090 0 27090.0 blue 1 1 gg 1854 0 1854.0 black 1 1 ff 3975 0 3975.0 black 1 1 dd 53620 0 53620.0 blue 1 1 ss 87226 0 87226.0 purple 1 1 qq 16000 0 16000.0 query 1 = to look the value ee which is located at column d ee =VLOOKUP(A67,D53:E65,2,FALSE) correct query 2 = to look the value of qq which is located also at column D but they have 2 quantities, so they have to add. answer = ??? thanks for helping. =) -- xxxJessexxx "Paul" wrote: -- xxxJessexxx

how about =SUMIF(D53:D65,a67,E53:E65) which says, if any rows in D53 to D65 = A67, sum the corrsponding values in E53:E65 "Jessejames" wrote: > this is my database > > (ROW and column A52 IS description) > > A B C D E > F G > description data b data c name tot tot a totb > > purple 1 1 qq 12000 0 12000.0 > yellow 1 1 ww 630 0 630.0 > blue 1 1 ee 1341 0 1341.0 > orange 1 1 rr 17548 0 17548.0 > black 1 1 tt 228 0 228.0 > purple 1 1 yy 131 0 131.0 > black 1 1 uu 27090 0 27090.0 > blue 1 1 gg 1854 0 1854.0 > black 1 1 ff 3975 0 3975.0 > black 1 1 dd 53620 0 53620.0 > blue 1 1 ss 87226 0 87226.0 > purple 1 1 qq 16000 0 16000.0 > > > query 1 = to look the value ee which is located at column d > > ee =VLOOKUP(A67,D53:E65,2,FALSE) > > correct > > query 2 = to look the value of qq which is located also at column D but they > have 2 quantities, so they have to add. > answer = ??? > > thanks for helping. > > =) > > > > > -- > xxxJessexxx > > > "Paul" wrote: > > > -- > xxxJessexxx

Hi Jesse Try =SUMIF(DD,"qq",E:E) or better still, place qq in a cell like A67 then use =SUMIF(DD,"="&A67,E:E) -- Regards Roger Govier Jessejames wrote: > this is my database > > (ROW and column A52 IS description) > > A B C D E > F G > description data b data c name tot tot a totb > > purple 1 1 qq 12000 0 12000.0 > yellow 1 1 ww 630 0 630.0 > blue 1 1 ee 1341 0 1341.0 > orange 1 1 rr 17548 0 17548.0 > black 1 1 tt 228 0 228.0 > purple 1 1 yy 131 0 131.0 > black 1 1 uu 27090 0 27090.0 > blue 1 1 gg 1854 0 1854.0 > black 1 1 ff 3975 0 3975.0 > black 1 1 dd 53620 0 53620.0 > blue 1 1 ss 87226 0 87226.0 > purple 1 1 qq 16000 0 16000.0 > > > query 1 = to look the value ee which is located at column d > > ee =VLOOKUP(A67,D53:E65,2,FALSE) > > correct > > query 2 = to look the value of qq which is located also at column D but they > have 2 quantities, so they have to add. > answer = ??? > > thanks for helping. > > =) > > > >

Roger, do you really need the equals in your second example? Plus, you missed a colon between the DD in both examples: =3DSUMIF(D:D,A67,E:E) Hope this helps. Pete On Apr 21, 5:25=A0pm, Roger Govier <ro...@technology4nospamu.co.uk> wrote: > Hi Jesse > > Try > =3DSUMIF(DD,"qq",E:E) > or better still, place qq in a cell like A67 then use > =3DSUMIF(DD,"=3D"&A67,E:E) > -- > Regards > Roger Govier > > > > Jessejames wrote: > > this is my database > > > (ROW and column A52 IS description) > > > =A0 =A0 =A0 =A0 =A0A =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 B =A0 =A0 =A0 =A0 = =A0 C =A0 =A0 =A0 =A0 =A0D =A0 =A0 =A0 =A0 =A0 =A0E =A0 =A0 =A0 =A0 =A0 =A0 > > =A0F =A0 =A0 =A0 =A0 =A0 =A0 =A0G > > =A0description =A0 data b =A0 =A0data c =A0 =A0 =A0name =A0tot =A0 =A0 = =A0 tot a =A0 =A0 =A0 =A0totb =A0 > > > purple =A0 =A0 =A0 =A0 =A0 1 =A0 =A01 =A0 =A0 =A0 qq =A0 12000 =A0 =A0 = =A00 =A0 =A012000.0 > > yellow =A0 =A0 =A0 =A0 =A0 1 =A0 =A0 =A0 =A0 =A0 =A01 =A0 =A0 =A0 ww = =A0 630 =A0 =A0 =A0 =A00 =A0 =A0630.0 > > blue =A0 =A0 =A0 =A0 =A0 =A0 1 =A0 =A01 =A0 =A0 =A0 ee =A0 1341 =A0 =A0= =A0 0 =A0 =A01341.0 > > orange =A0 =A0 =A0 =A0 =A01 =A0 =A0 1 =A0 =A0 =A0 rr =A0 17548 =A0 =A0 = =A0 =A0 =A0 =A0 =A0 0 =A0 17548.0 > > black =A0 =A0 =A0 =A0 =A0 1 =A0 =A0 1 =A0 =A0 =A0 tt =A0 228 =A0 =A0 = =A0 =A0 0 =A0 228.0 > > purple =A0 =A0 =A0 =A0 1 =A0 =A0 =A01 =A0 =A0 =A0 yy =A0 131 =A0 =A0 = =A0 =A0 0 =A0 131.0 > > black =A0 =A0 =A0 =A0 1 =A0 =A0 =A0 1 =A0 =A0 =A0uu =A0 =A027090 =A0 = =A0 =A00 =A0 =A027090.0 > > blue =A0 =A0 =A0 =A0 =A01 =A0 =A0 =A0 1 =A0 =A0 =A0gg =A0 =A01854 =A0 = =A0 =A0 0 =A0 =A01854.0 > > black =A0 =A0 =A0 =A0 1 =A0 =A0 =A0 1 =A0 =A0 =A0ff =A0 =A03975 =A0 =A0= =A0 0 =A0 =A03975.0 > > black =A0 =A0 =A0 =A0 1 =A0 =A0 =A0 1 =A0 =A0 =A0dd =A0 =A053620 =A0 = =A0 =A00 =A0 =A053620.0 > > blue =A0 =A0 =A0 =A0 =A01 =A0 =A0 =A0 1 =A0 =A0 =A0ss =A0 =A087226 =A0 = =A0 =A00 =A0 =A087226.0 > > purple =A0 =A0 =A0 =A01 =A0 =A0 =A0 1 =A0 =A0 =A0qq =A0 =A016000 =A0 = =A0 =A00 =A0 =A016000.0 > > > query 1 =3D to look the value ee which is located at column d > > > ee =A0=3DVLOOKUP(A67,D53:E65,2,FALSE) > > > correct > > > query 2 =3D to look the value of qq which is located also at column D b= ut they > > have 2 quantities, so they have to add. > > answer =3D ??? > > > thanks for helping. > > > =3D)- Hide quoted text - > > - Show quoted text -

Quite right, Pete! Typing too quickly, and my mind was elsewhere!!! -- Regards Roger Govier Pete_UK wrote: > Roger, > > do you really need the equals in your second example? Plus, you missed > a colon between the DD in both examples: > > =SUMIF(D:D,A67,E:E) > > Hope this helps. > > Pete > > On Apr 21, 5:25 pm, Roger Govier <ro...@technology4nospamu.co.uk> > wrote: >> Hi Jesse >> >> Try >> =SUMIF(DD,"qq",E:E) >> or better still, place qq in a cell like A67 then use >> =SUMIF(DD,"="&A67,E:E) >> -- >> Regards >> Roger Govier >> >> >> >> Jessejames wrote: >>> this is my database >>> (ROW and column A52 IS description) >>> A B C D E >>> F G >>> description data b data c name tot tot a totb >>> purple 1 1 qq 12000 0 12000.0 >>> yellow 1 1 ww 630 0 630.0 >>> blue 1 1 ee 1341 0 1341.0 >>> orange 1 1 rr 17548 0 17548.0 >>> black 1 1 tt 228 0 228.0 >>> purple 1 1 yy 131 0 131.0 >>> black 1 1 uu 27090 0 27090.0 >>> blue 1 1 gg 1854 0 1854.0 >>> black 1 1 ff 3975 0 3975.0 >>> black 1 1 dd 53620 0 53620.0 >>> blue 1 1 ss 87226 0 87226.0 >>> purple 1 1 qq 16000 0 16000.0 >>> query 1 = to look the value ee which is located at column d >>> ee =VLOOKUP(A67,D53:E65,2,FALSE) >>> correct >>> query 2 = to look the value of qq which is located also at column D but they >>> have 2 quantities, so they have to add. >>> answer = ??? >>> thanks for helping. >>> =)- Hide quoted text - >> - Show quoted text - >

Similiar Articles:

Sumif with references on different tabs - microsoft.public.excel ...
Excel - Indirect, Sumif, Vlookup With Multiple Sheet Names Help ... Indirect, Sumif, Vlookup With Multiple Sheet Names Help ... I am familiar with using an indirect ...

Index match or Sumif ??? - microsoft.public.excel.worksheet ...
VLOOKUP uses the second column ... Excel: Fastest search methods (Vlookup, SumIf, Match/Index etc.) ... I have two ... Index Data That Match Multiple Conditions ...

vlookup across multiple pages - microsoft.public.excel.worksheet ...
... CORNER!$A$12:$D$100,2,TRUE) + VLOOKUP(B6,BARN_YARD!$A$12:$D$100,2,TRUE) + VLOOKUP(B6,BEAVER_DAM!$A$12:$D$100,2,TRUE) + VLOOKUP....etc Any suggestions? SUMIF doesn ...

Sumproduct with sumif over mutiple worksheets - microsoft.public ...
Can a SUMPRODUCT array formula be used across multiple worksheets ... VLookup Function over ... Sumproduct/sumif/indirect Across Multiple Workbooks, Worksheets, Multiple ...

SumIf across multiple worksheets - microsoft.public.excel ...
Can I combine a Vlookup with an IF formula? - microsoft.public ... VLookup Function over Multiple Worksheets - microsoft.public ... from Peo S a few years ago, this ...

can I use vlookup to add multiple values - microsoft.public.excel ...
Is it possible to use the vlookup or other function to total all the values that ... With the data "as-is", via formulas, think SUMIF ... In C2, copied down: =SUMIF(A:A ...

Multiple vlookup and adding values together - microsoft.public.mac ...
I don't believe you'll need VLOOKUP() for this. Have a look at SUMIF() instead. -- HTH |:>) Bob Jones [MVP] Office:Mac <oddball1405@officeformac.com> wrote in ...

Vlookup in multiples columns - microsoft.public.excel.worksheet ...
Two Condition Vlookup - microsoft.public.excel.misc VLOOKUP uses the second column ... Excel: Fastest search methods (Vlookup, SumIf, Match/Index etc.) ...

Using SUMIF to add data between a range of dates - microsoft ...
Using SUMIF to add data between a range of dates - microsoft ..... vlookup to specify the specific row I wanted to ... Range =SUMIF ... Date Range I am trying to sum ...

V Lookup and Multiple Values - microsoft.public.excel.worksheet ...
Answers Best Answer: I don't think you can do it with the vlookup, because that stops when it finds the first matching cell, but I suggest trying the sumif ...

Using Excel Sumif or Vlookup Functions | Experiments in Finance
One of the questions that we have been receiving quite a bit in recent months has been regarding the difference between the Sumif and Vlookup functions in excel.

Excel - Sumif Using Vlookup As Criteria - Is the SUMIF... - Free ...
Sumif Using Vlookup As Criteria - Is the SUMIF function able to use a VLOOKUP as a criteria... - Free Excel Help

Excel - Help Vlookup/sumif/vba??? - I have a spreadsheet... - Free ...
Help Vlookup/sumif/vba??? - I have a spreadsheet I use for recording data on each... - Free Excel Help

How to combine VLOOKUP with SUMPRODUCT/SUMIF?: Microsoft, Office ...
Dear experts... I am trying to sum a column based on information in other columns with Excel 2003. The structure of the data is as follows: Sheet 1 (Table1 ...

SUMIF And VLOOKUP - Excel Help Forum
Hi, I set up a SUMIF forumula shown below; Please note that the formula is set up in "Data Table 2": "=SUMIF('Data Table 1'!E5:E100,A3,'Data Table 1'!G5:G100 ...

7/6/2012 6:09:44 AM