SumProduct function

V

Vicky

I have 6 columns, which looks like this, I want the sum of all the Ideal time
and Achieved time for A01, A02 and A03 respectively

ID Ideal time achieved time Ideal time Achieved time IDeal time
achieved time
A01 45 50 35 30
30 50
A02 50 35 37 33
25 41
A03 35 25 40 35
60 55

Thanks in Advance!!
Vicky
 
R

Roger Govier

Hi Vicky

there is nothing wrong with the formula, it must be your data.
To have a #Value error, I would suspect that you have some Text within the
data area
 
V

Vicky

Sorry for replying late,

I used the formulat =SUMPRODUCT(--($B$1:$G$1=$I$1),B2:G2)
Ideal time Achieved time Ideal time Achieved time Ideal time Achieved
time Ideal time Achieved time
A01 45 50 35 30 30 50 110
A02 50 35 37 33 25 41 112
A03 35 25 40 35 60 55 135

Thx,
Vicky
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top