Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to sum values across rows with certain features
So let's say I have a table like this:
ID Date Value 2 6/2 2432 2 6/2 1322 3 6/2 3534 3 6/2 6431 2 6/3 2421 2 6/2 6251 3 6/3 9870 3 6/2 3534 I want a function that will find every row with an ID "2" and a date "6/2", and then add together all the "Values". So if I ran the function with those parameters it would return 3754. I can do this with a pivot table but I would love a formula to do it instead. Any ideas? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to sum values across rows with certain features
Hi David,
Am Mon, 25 Jun 2012 13:19:56 -0700 (PDT) schrieb David Tannenbaum: ID Date Value 2 6/2 2432 2 6/2 1322 3 6/2 3534 3 6/2 6431 2 6/3 2421 2 6/2 6251 3 6/3 9870 3 6/2 3534 I want a function that will find every row with an ID "2" and a date "6/2", and then add together all the "Values". So if I ran the function with those parameters it would return 3754. what excel version do you use? xl2007 or xl2010: =SUMIFS(C:C,A:A,2,B:B,DATE(2012,6,2)) An earlier version: =SUMPRODUCT(--(A1:A100=2),--(B1:B100=DATE(2012,6,2)),C1:C100) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying Multiple Values without using Macros or ROWS function | Excel Worksheet Functions | |||
frequency function and list features | Excel Worksheet Functions | |||
Match Values in Rows with Partial Values in Columns | Excel Worksheet Functions | |||
Hiding Specific Rows Based on Values in Other Rows | Excel Worksheet Functions | |||
Delete rows with numeric values, leave rows with text | Excel Programming |