Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Today I had need to bring into my Sheet2 some data off of Sheet1;
My Sheet1 data (Column and Row#'s provided) G H J K 12 450300 Widget1 1,234.00 Y 13 500200 Widget2 2,111.00 Y 14 450300 Widget3 3,111.00 N 15 650200 Widget4 4,111.00 Y 15 450300 Widget5 5,111.00 Y 15 353700 Widget6 6,111.00 Y 16 450300 Widget7 2,333.00 N On mY Sheet 2 I need to Bring bank the sum of ColJ of all records where ColG = 450300 and ColK = Y the answer would be 6,345.00 What would formula be? Can/Should I use a: Sumif() Sumproduct() An Array-entered formula TIA, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"criteria" in a sumif refering to the value in another cell | Excel Discussion (Misc queries) | |||
SUMIF function - criteria of between two dates. How? | Excel Worksheet Functions | |||
sumif with multiple criteria | Excel Worksheet Functions | |||
How do I ask for multiple criteria when creating a "sumif" formul. | Excel Worksheet Functions | |||
Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions |