countifs

[lescrowe]

Hi, hoping someone can help.

I have the formula which I thought was correct but it is not picking up any data.

=COUNTIFS(Applications!$D$3:$D$300,"=$a$3",Applications!$E$3:$E$300,"=$d$2")

There is an "a3" in column d and a "d2" in column e.

I only require to count how many times "d2" appears in column e if "a3" appears in column d.
e.g. column d has the name of an loan introducer. Column e has the result (declined/approved). I need to know how many declined/approved loans the introducer has each month.

Hope you understand what I am trying to achieve.

Thanks for looking.

[NeedForExcel]

Try this

=COUNTIFS(Applications!$D$3:$D$300,"a3",Applications!$E$3:$E$300,"d2")

[lescrowe]

Sorry, same result.

[FDibbins]

is a3 text or a cell reference?

[NeedForExcel]

Can you post a sample file so that it becomes easier to answer?

[lescrowe]

a3 is a cell reference

will post up the sheet.

[shukla.ankur281190]

=COUNTIFS(Applications!$D$3:$D$300,A3,Applications!$E$3:$E$300,D2)

Put Above one.

[lescrowe]

Thank you Ankur - all done!!

[shukla.ankur281190]

Glad it helps you.
You must know that if any thing you will put in double Quote " " will treat by excel as text.