Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Can anyone help me with this one please? I have this table of data. I'd like
to be able to write a formula(s) which sums the No according to date and code, but then only returns a sum value (with the code and date in the two adjacent cells) if there is a value greater than 0. Code Ref No Date 1 G/032/05/999 400600 212 19/03/2010 2 G/032/03/001/999 400500 50 19/03/2010 3 G/032/02/001/001 400400 170 19/03/2010 4 G/032/05/999 400600 315 19/03/2010 5 G/032/03/001/999 400500 300 19/03/2010 6 G/032/05/999 400600 202 19/03/2010 7 G/032/03/001/002 400500 85 19/03/2010 8 G/032/05/999 400600 238 19/03/2010 9 G/032/03/001/002 400500 170 19/03/2010 10 G/032/02/001/001 400400 170 20/03/2010 11 G/032/05/999 400600 53 20/03/2010 12 G/032/03/001/999 400500 430 21/03/2010 13 G/032/05/999 400600 371 21/03/2010 The result of formula(s) would look something like: G/032/05/999 19/03/2010 967 G/032/03/001/999 19/03/2010 350 G/032/02/001/001 19/03/2010 170 and so on..... I think I'm wishing for the moon, but would solve a major headache in my daily working life!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count w/ multiple variables & text values | Excel Worksheet Functions | |||
Refer to adjacent cells as variables in formula | Excel Discussion (Misc queries) | |||
Find a Match in Multiple Places & Return Multiple Values | Excel Worksheet Functions | |||
Lookup in Multiple Columns, Return Multiple Values | Excel Worksheet Functions | |||
Search multiple values to return single values | Excel Worksheet Functions |