Sumproduct and if statement

[neilsinc]

Is it possible to use sumproduct and if statements together, or is there an easier way of achieving what I need to do here?

I have the following formula:

=SUMPRODUCT(--(Statement!$J$1:$J$1724=C13),Statement!$L$1:$L$1724)

What this does is look at my bank statement sheet for a particular line (C13), for example "Subscription Fees", and returns the total amount in column L for all with the note of subscription fees.

What I want to do is narrow it down even further. There is another column that indicates either income or expenditure. What I need is to basically say:

Where column J is "Subscription Fees" AND "Income", then return the amount in column L.

What would be the best way to do this? Perhaps the sumproduct function isn't the best any longer.

Thanks in advance for any help

 

[Special-K99]

Where column J is "Subscription Fees" AND "Income"

How can something be 2 things at once?
Do you mean OR ?
Do you mean

Where column J is "Subscription Fees" OR "Income"

"There is another column that indicates either income or expenditure"

An as yet unspecified column.
What column would that be then?

 

[Special-K99]

if you mean OR then

=SUMPRODUCT(((Statement!$J$1:$J$1724="Subscription Fees")+(Statement!$J$1:$J$1724="Income")) *(Statement!$L$1:$L$1724))

 

[Fluff]

You haven't said what column has "Income", but try something like
=SUMPRODUCT((Statement!$J$1:$J$1724=C13)*(Statement!$K$1:$K$1724="Income"),Statement!$L$1:$L$1724)
Change values in red to the Income column

 

[neilsinc]

You haven't said what column has "Income", but try something like
=SUMPRODUCT((Statement!$J$1:$J$1724=C13)*(Statement!$K$1:$K$1724="Income"),Statement!$L$1:$L$1724)
Change values in red to the Income column

Apologies guys, should've said that Income/Expenditure is in column M. The above looks like it has worked though, when I've adjusted to the correct columns. Thanks very much

 

[Fluff]

Glad we could help & thanks for the feedback