Excel - Group Total

Any body pls help......

Sheet1

Date/Week/Month/Category/Amount spend
1/1/Jan/Food/100
1/1/Jan/Travell/50
1/1/Jan/Fuel/200
2/2/Jan/......
2/2/Jan/......



Sheet2
Column-A/Column-B

Week/Total spend
1/350
2/300
3/...
4/... etc


Is there any formula to add all the week-1 expenditure in Sheet1 and show in
Sheet2 (Column-B)

  Don Guillett replied to RE: VLOOKUP fORMULA

Look in the help index for SUMIF. Does your example add up?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

  Jacob Skaria replied to RE: VLOOKUP fORMULA

In Sheet2 with cell A2 having weeknumber try this formula in cell B2

=sumif(Sheet1!B:B,A2,Sheet2!E:E)


If this post helps click Yes
---------------
Jacob Skaria

sumproduct or sumif? Excel Excel 2003 On the first sheet (FY2007MonthlyCosts), I have names in column A. Column B, D has dollars. I sum the hours and dollars in cells IU and IV with this: SUMIF($B$4:$IT$4, "hours", B5:IT5) SUMIF($B$4:$IT$4, "Dollars", B5:IT5) These are copied down for each name (row On the second sheet (FY2007Summary), I use another sumif to find the data by name. SUMIF('FY2007Monthly Costs'!A5:A38, FY2007Summary!A6, 'FY2007Monthly Costs'!IU5:IU38) This works but I was looking for an easier one step formula to use on the Summary sheet. Excel Miscellaneous Discussions Excel 2003 (1) Named range (1) SUMPRODUCT (1) VLOOKUP (1) SUMIF (1) FY2007MonthlyCosts

SUMIF - VLOOKUP Excel I have a 2007 file which has sales for each day from August to the 10 55555 11 / 14 / 08 Aug 11 555556 Nov 14 444444 . . . . . . . . . 88888 Dec 14 77777 Excel Miscellaneous Discussions SUMPRODUCT (1) DATEVALUE (1) Workbook (1) VLOOKUP (1) SUMIF (1) Report (1) Perfomance (1) Serializer (1) use SUMPRODUCT. I assume the dates in column dates in the workbook = countif(- -(book1!a1:a100> = DATEVALUE("8 / 1 / 07")), book1!b1:b100) = sumif(A:A, < = rundate, B:B) Your formula is not working. I also forgot to mention 2 rows with data in between the date column and sales column. Did you try = sumif(A:A, < = rundate, D:D) Hi, I am attempting to perform a vlookup and sum

Complex SUMPRODUCT / VLOOKUP / SUMIF Excel Hi there, hope someone can help. I have a summary table within a spreadsheet where for forecast). Hopefully this is clear! If anyone can help I would appreciate it. Thanks Excel Worksheet Discussions SUMPRODUCT (1) VLOOKUP (1) SUMIF (1) MATCH (1) INDEX (1) Actuals (1) Works like a dream! Corrected an ommission in the formula (missed out a comma). = SUMIF($U$16:$AF$16, $E$4, INDEX($U$18:$AF$100, MATCH($D4, $T$18 T$100, 0), )) Thanks a lot! keywords: Complex, SUMPRODUCT / VLOOKUP / SUMIF description: Hi there, hope someone can help. I have a summary table within a

Vlookup Excel Is it possible to have a sum in a Vlookup? Excel Worksheet Discussions Microsoft Excel (1) MEubT1IWP8 (1) VLOOKUP (1) FLOOR (1) SUMIF (1) INT (1) MID (1) SUM (1) See if this is what you had in x. . . . . . . . . . .1 4. . . . . . . . x. . . . . . . . . . .4 5. . . . . . . . y. . . . . . . . . . .2 Sum column B where column A = x: = SUMIF(A1:A5, "x", B1:B5) - - Biff Microsoft Excel MVP Can I send you a sample

sumif function Excel = sumif(range, criteria, sum_range) Suggestion: to allow the sumif function to work even if (. . . . sum_range) be replaced by cell formula, just like vlookup function. example = vlookup(criteria, range, off-set column, false) where offset can be replaced by a cell with value 1, 2, 3 etc What I mean for sumif function, if sum_range (is column B:B) can be replaced by a cell contains "B office / community / en-us / default.mspx?mid = 7b6cec61-dd67-4645-a757-9f25b0e5ff56&dg = microsoft.public.excel.worksheet.functions Excel Worksheet Discussions Microsoft Excel (1) Worksheet (1) INDIRECT (1) SUMIF (1) Rgds