| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum with a Twist Q
How could I add up all values in two ranges where the value in a
separate range equals one of 2 values? As an example I wish to add all values in Ranges H10:H22 IF the corresponding value in J10:J22 is one of 333333 or 444444 or 1111111 or 2222222 + All values in Ranges H28:H40 IF the corresponding value in J28:J40 is one of 333333 or 444444 or 1111111 or 2222222 + etc etc An alternative to above that might be neat is:- Add all values in Ranges H10:H22 IF the corresponding value in J10:J22 is a continuous 6 or 7 digit value i.e. 333333 or 444444 or 1111111 or 2222222 + etc etc |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Top Ten Lists with a twist (or three). | Excel Worksheet Functions | |||
| If but with a twist:( | New Users to Excel | |||
| Sum with a twist | Excel Discussion (Misc queries) | |||
| Match with a Twist | Excel Worksheet Functions | |||
| Cut / Paste with a Twist | Excel Discussion (Misc queries) | |||
Threaded Mode
