Adding an additional forumula to my SUMPRODUCT formula

M

Mark D

Good afternoon everyone

I am sure this is pretty simple but everything I am trying isn't working,
Hoping someone can help

I have the following formula

=IF(SUMPRODUCT(($C69=1)*($C90<L$3)),L69,"")

Works prefectly, But I want to add to the start of it

IF B2="EX","" otherwise run the sumproduct formula above

many thanks
 
J

Jacob Skaria

Try..

=IF(B2="EX","",<your formula>)

'or will this do?
=IF(AND(B2="EX",C69=1,C90<L3),L69,"")
 

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

Similar Threads

Adding to a SUMPRODUCT formula 6
Sumproduct formula help (possible Index????) 7
Adding another if statement to an index formula 0
I think I know how to ask this sumproduct question now: 5
Need to add to a SUMPRODUCT formula 2
Need a proper guru! My head hurts ;( 1
excel formula sumproduct and age ranges 3
Create One Formula for Entire Column 1

Top