Home |
Search |
Today's Posts |
#1
|
|||
|
|||
H - SumProduct
Hi there, need help again!!!
This is what I have A B C D E ... YTD 1 Jan Feb Mar Apr May 2 X 100 200 300 500 600 =Sum(B1:B5) = 1700 3 Y 100 100 100 100 100 =Sum(C1:C5) = 500 I need a Formula that can calculate based on a criteria on a Cell 4 Feb Mar 5 Sum(X YTD C4) = 300 Sum(X YTD D4) = 600 6 Sum(Y YTD C4) = 200 Sum(X YTD D4) = 300 Sumporduct & Sumif can do this in rows, what I am looking for is the same function but thought columns |
#2
|
|||
|
|||
What are you trying to do? You seem to be confusing rows and columns.
=Sum(B1:B5) = 1700 ... ? I think that should be =Sum(B2:F2) = 1700 The January heading is in B1, hence the data for January for product X is in cell B2, for February in cell C2 and so on. So, the year to date total for product X would be: =Sum(B2:M2) in cell N2, for example. The sum for February would be =SUM(C:C) and the sum for March would be =SUM(D:D) Regards Trevor "MESTRELLA29" wrote in message ... Hi there, need help again!!! This is what I have A B C D E ... YTD 1 Jan Feb Mar Apr May 2 X 100 200 300 500 600 =Sum(B1:B5) = 1700 3 Y 100 100 100 100 100 =Sum(C1:C5) = 500 I need a Formula that can calculate based on a criteria on a Cell 4 Feb Mar 5 Sum(X YTD C4) = 300 Sum(X YTD D4) = 600 6 Sum(Y YTD C4) = 200 Sum(X YTD D4) = 300 Sumporduct & Sumif can do this in rows, what I am looking for is the same function but thought columns |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct | Excel Worksheet Functions | |||
sumproduct causing memory errors? | Excel Worksheet Functions | |||
Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |