combining a Countif and Countifs formula

[Ollie75]

I am new and struggling getting my head around a few formulas.

I currently have the following formulas

1. =COUNTIFS(Leads!$S$11:$S$400,A16,Leads!C14:C403,$G$2)
2. =SUMIFS(Leads!$K$11:$K$400,Leads!$C$11:$C$400,$G$2,Leads!$S$11:$S$400,A16)
3. =SUMPRODUCT((F11:F400<>"")/COUNTIF(F11:F400,F11:F400&""))

All 3 work fine however I wish to add No 3 to both the first and second formula.

The first formula counts cells with a certain criteria, the second gives a total of cells under a certain criteria and the third looks for unique cells in column F that are not blank.

google has provided me with multiple options that are too complicated for me to understand let alone consider applying my conditions to.

Hope this makes sense

cheers


Ollie

 

[istiasztalos]

Hi Ollie,

What do you mean by "add No 3 to both formulas"?

I'd like to understand what you are trying to achieve.

Thanks

 

[Ollie75]

I need the answer from each of the first two but only when there is a unique Text entry in column F.

Hope this helps explain it

 

[Aladin Akyurek]

I need the answer from each of the first two but only when there is a unique Text entry in column F.

Hope this helps explain it

You could post first 10 rows from each range, i.e.

Leads!C14:C23

Leads!F11:F20

Leads!K11:K20

Leads!S11:S10

Post these one followed by the other (not next to each other), provide also the values for A16 and G2.

Finally, provide the count and the total you expect when taking the unique items in F of Leads in consideration.