Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT or SUMIF
On sheet one I have: Columns;C, D, E, J & Rows; 9, 10, 11, 12, 13, 14 as an
example. Column: C is for quantities, D is for sizes, E is for grades, J is for length : C D E J ------------------------------------------ 9: 4 .625 SAE 1.50 10: 6 .625 SAE 1.50 11: 4 .500 A325 1.75 12: 6 .500 A325 1.75 13: 8 .500 SAE 1.50 14: 6 .75 A325 2.25 On sheet two (summary sheet) I have the following as example: Columns: A (size), B (lenght), C (quantities) & rows 20, 21, 22 for A325 and rows 32, 33, 34 for SAE. I would like to see a total quantity shown in column C if I type in size in column A and length in column B for each sizes of same grade & lenght. I get confused with SUMIF or SUMPRODUCT. Can someone un-confuse me with this problem please. Thank you in advance. Serge |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif and sumproduct together | Excel Discussion (Misc queries) | |||
SUMIF Function Inside SUMPRODUCT Function | Excel Worksheet Functions | |||
SUMPRODUCT or SUMIF | Excel Worksheet Functions | |||
SUMPRODUCT or SUMIF or ... | Excel Worksheet Functions | |||
Sumif not Sumproduct | Excel Worksheet Functions |