| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Thanks, this helped
Jai "tonywig" wrote: Something like this? =IF(B2<C2,"-",SUMIF(C$2:C$4,B2,D$2:D$4)) Where vendor number is different to group, no value is summed. Where vendor number = group (i.e. it is the first in a group or it is not in a group) then sum everything for that group. -- tonywig ------------------------------------------------------------------------ tonywig's Profile: http://www.excelforum.com/member.php...o&userid=18985 View this thread: http://www.excelforum.com/showthread...hreadid=381718 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to lookup table in another Worksheet please | Excel Worksheet Functions | |||
| Lookup formula | Excel Discussion (Misc queries) | |||
| Can't find the right lookup formula for this | Excel Worksheet Functions | |||
| Formula Question... LookUP | Excel Discussion (Misc queries) | |||
| Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Hybrid Mode
