H - SumProduct

[Guest]

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

 

[Trevor Shuttleworth]

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)


Regards

Trevor