| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum multiple columns with SUMIF or SUMPRODUCT
I'm running Excel 2003 and am having trouble with what I thought should be a
relatively simple formula. Given a matching criteria in column A, I'd like to sum columns B:D. I've taken a stab at it with the following formulas, but they all return "#Value" 1st try =SUMIF(A1:A3="x","B1:D3) 2nd try =SUMPRODUCT(--(A1:A3="x"),B1:D3) 3rd try =SUMPRODUT((A1:A3="x")*(B1:B3+C1:C3+D1:D3)) Any advice??? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiple sumif or sumproduct | Excel Worksheet Functions | |||
| multiple if conditions - use sumif/sumProduct? | Excel Discussion (Misc queries) | |||
| SUMPRODUCT, SUMIF, COUNTIF for multiple sheets for multiple criter | Excel Worksheet Functions | |||
| SUMPRODUCT / SUMIF on Multiple Worksheets with Multiple Criteria | Excel Discussion (Misc queries) | |||
| SUMif or SUMproduct across multiple worksheets? | Excel Worksheet Functions | |||
Threaded Mode
