| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum if with multiple ranges
Here is what my spreadsheet looks like. These are are grouped by weeks, so
each person will have multiple entries down column A. A B John 1/14 16 1/15 15 Jane 1/14 16 1/15 12 Joe 1/14 10 1/15 13 I'm looking for a formula to add say all of Johns values based on a certain date. I've tried sumif but it will not let me use multiple ranges. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple ranges with the same name | Excel Discussion (Misc queries) | |||
| Multiple Ranges = same value | Excel Discussion (Misc queries) | |||
| Multiple IF statements looking up multiple ranges. | Excel Worksheet Functions | |||
| Can I create Multiple passwords to edit multiple ranges? | Excel Discussion (Misc queries) | |||
| How do i update multiple data ranges across multiple worksheets? | Excel Discussion (Misc queries) | |||
![TB@work[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
