| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif or sumproduct with a left statement
I currently have the following formula :
=SUMPRODUCT(--(LEFT(Xfers!C:C,6)="834097"),(Xfers!H:H)) which this works great for items occurring in column c, but i also need it to sum column H when column E's first 6 characters = 834097 but i don't want it to count them twice. So if column C and E match then it shouldn't sum column H twice. Can someone help me with this? Thanks -- Eric |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum if statement with a left statement | Excel Discussion (Misc queries) | |||
| SUMPRODUCT AND LEFT | Excel Worksheet Functions | |||
| Sumif/vlookup/left | Excel Discussion (Misc queries) | |||
| SUMIF and LEFT and Named Ranges | Excel Worksheet Functions | |||
| Left and Sumproduct | Excel Discussion (Misc queries) | |||
Threaded Mode
