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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum if with multiple ranges
On Jan 20, 10:54*am, TB@work wrote:
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. Is john in A or a seperate column. Becasue it looks like your names are above a series of dates. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum if with multiple ranges
It is not a seperate column.
"jlclyde" wrote: On Jan 20, 10:54 am, TB@work wrote: 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. Is john in A or a seperate column. Becasue it looks like your names are above a series of dates. . |
Reply |
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) |