sumif or suproduct--with two cretarias
 

Dear All,

I have a peculiar proble which I don't know wether I use sumif or sumprodut?

My data
A B Result
1 SRA Online Checks: BS - Assets
2 JRA Online Checks: BS - Assets
3 SRA Online Checks: BS - Liabilities
4 JRA Online Checks: BS - Liabilities

Source data:

F G H I J
1 Description JRA RA SRA Analyst
2 Online Checks: BS - Assets 37.65 41.18 47.06 52.94
3 Online Checks: BS - Liabilities 35.29 41.18 52.00 64.71

My requirement:
I need the value where the A1 and B1 match with the source data and present
the value of matching. Here, in result column, firs value should be 47.06
and secund value should be 37.65.

I hope you people underastand the problem. Thanks in advance.

sumif or suproduct--with two cretarias
 

=SUMPRODUCT((A1=$G$1:$J$1)*(B1=$F$2:$F$3)*($G$2:$J $3))

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Narendra Boga" wrote:

Dear All,

I have a peculiar proble which I don't know wether I use sumif or sumprodut?

My data
A B Result
1 SRA Online Checks: BS - Assets
2 JRA Online Checks: BS - Assets
3 SRA Online Checks: BS - Liabilities
4 JRA Online Checks: BS - Liabilities

Source data:

F G H I J
1 Description JRA RA SRA Analyst
2 Online Checks: BS - Assets 37.65 41.18 47.06 52.94
3 Online Checks: BS - Liabilities 35.29 41.18 52.00 64.71

My requirement:
I need the value where the A1 and B1 match with the source data and present
the value of matching. Here, in result column, firs value should be 47.06
and secund value should be 37.65.

I hope you people underastand the problem. Thanks in advance.

sumif or suproduct--with two cretarias
 

Its working..... Thank You very much...

Narendar




"Ms-Exl-Learner" wrote:

=SUMPRODUCT((A1=$G$1:$J$1)*(B1=$F$2:$F$3)*($G$2:$J $3))

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Narendra Boga" wrote:

Dear All,

I have a peculiar proble which I don't know wether I use sumif or sumprodut?

My data
A B Result
1 SRA Online Checks: BS - Assets
2 JRA Online Checks: BS - Assets
3 SRA Online Checks: BS - Liabilities
4 JRA Online Checks: BS - Liabilities

Source data:

F G H I J
1 Description JRA RA SRA Analyst
2 Online Checks: BS - Assets 37.65 41.18 47.06 52.94
3 Online Checks: BS - Liabilities 35.29 41.18 52.00 64.71

My requirement:
I need the value where the A1 and B1 match with the source data and present
the value of matching. Here, in result column, firs value should be 47.06
and secund value should be 37.65.

I hope you people underastand the problem. Thanks in advance.

sumif or suproduct--with two cretarias
 

You are welcome!

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Narendra Boga" wrote:


Its working..... Thank You very much...

Narendar




"Ms-Exl-Learner" wrote:

=SUMPRODUCT((A1=$G$1:$J$1)*(B1=$F$2:$F$3)*($G$2:$J $3))

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Narendra Boga" wrote:

Dear All,

I have a peculiar proble which I don't know wether I use sumif or sumprodut?

My data
A B Result
1 SRA Online Checks: BS - Assets
2 JRA Online Checks: BS - Assets
3 SRA Online Checks: BS - Liabilities
4 JRA Online Checks: BS - Liabilities

Source data:

F G H I J
1 Description JRA RA SRA Analyst
2 Online Checks: BS - Assets 37.65 41.18 47.06 52.94
3 Online Checks: BS - Liabilities 35.29 41.18 52.00 64.71

My requirement:
I need the value where the A1 and B1 match with the source data and present
the value of matching. Here, in result column, firs value should be 47.06
and secund value should be 37.65.

I hope you people underastand the problem. Thanks in advance.