Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sumproduct
Hi there, row 1 has either Section I or Section II in it Row 2 has numbers both rows run from A to BY In BZ I need to sum all section I In CA I need to sum all section II Eg a1 section I a2 10 b1 section II b2 5 c1 Section II C2 8 so sum of section II should be 13 Thanks!!!! Darin *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sumproduct
=SUMIF(A1:BY1,"Section I",A2:BY2)
=SUMIF(A1:BY1,"Section II",A2:BY2) -- HTH, Bernie MS Excel MVP "Darin Kramer" wrote in message ... Hi there, row 1 has either Section I or Section II in it Row 2 has numbers both rows run from A to BY In BZ I need to sum all section I In CA I need to sum all section II Eg a1 section I a2 10 b1 section II b2 5 c1 Section II C2 8 so sum of section II should be 13 Thanks!!!! Darin *** Sent via Developersdex http://www.developersdex.com *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sumproduct
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with SumProduct | Excel Worksheet Functions | |||
Sumproduct with Condition OR Sumproduct with ADDRESS function - HE | Excel Discussion (Misc queries) | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
sumproduct | Excel Discussion (Misc queries) |