Thread: H - SumProduct
View Single Post
  #1   Report Post  
MESTRELLA29
 
Posts: n/a
Default 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