If Then Formula

[jmaloney28]

I have a spreadsheet that I need to figure out the formula as follows:

If e4:e69 has a text such as "Referral" and on that same row F4:F69 has "yes" i need it to add a value of one to C75, not sure if this makes sense but kind of confused. Not sure if I have given enough information but if someone could give me some help on the If Then formula that would be great.

Thanks for your help!

[Jonmo1]

Try the countifs function in C75

=COUNTIFS(E4:E69,"Referral",F4:F69,"Yes")

[jmaloney28]

Thanks Jonmo1, that worked great!

I got one more for you then, with that calculation if I have a "Yes" in F4:F69 then there is a sales value placed in G4:G69. What formula would I use to add that sales amount to E75?

Thanks again!

[Jonmo1]

That's SUMIF

=SUMIF(F4:F69,"Yes",G4:G69)