#1
|
|||
|
|||
Issue With SUMIF and Range
I have a spreadsheet (attached) and I want to use SUMIF.
However, I want to use a range of cells (multiple cells/rows) to get the sum. It appears that only the first column is used to get the sum. What are my options? Tommy |
#2
|
||||
|
||||
Use SUMIFS for multiple criteria/range.
|
#3
|
|||
|
|||
Hi, see the next links...
SUMIF function "Sum_range should be the same size and shape as range. If it isn't, performance may suffer, and the formula will sum a range of cells that starts with the first cell in sum_range but has the same dimensions as range." SUMIFS function "The Criteria_range argument must contain the same number of rows and columns as the Sum_range argument." |
#4
|
||||
|
||||
You can use:
=SUMPRODUCT(($A$2:$A$20=D22)*$D$2:$F$20) in D23 and copy across. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Using SUMIF to pull text from another cell as range | kong1802 | Excel | 2 | 02-07-2017 11:04 AM |
Sumif with various conditions in the same range | Haha88 | Excel | 8 | 12-28-2016 09:15 PM |
Sumif based on date range | Skumby | Excel | 2 | 07-28-2016 10:39 PM |
MS Project Date Range Issue | appelguy@gmail.com | Project | 2 | 10-31-2015 11:52 AM |
Sumif with multiple sum range | Haha88 | Excel | 6 | 10-29-2015 03:26 AM |