COUNTIF or COUNT formula help required

Dear All,

Please help me to following situation, data is arranged as below;

In row A serial numbers from A2:A3726 is mentioned

In row B sales person name is appearing from B2:B3726 (there are 8 different names appearing repeatedly without any sequence)

In row C fix items (products) are appearing from C2:C3726 (eg Banana, Apple, Orange etc)

In row D month is appearing from D2:D3726 (for eg JAN, FEB, MAR etc)

Now if I want to count how many times Mr. A had sold ITEM X in the month of JAN? For this I tried following formulas:
{=COUNTIF(A2:A3726,(SUM(B2:B3726="Mr. A")*(C2:C3726="Banana")*(D2:D3726="JAN"))} but this is not working

Or I may put my question again if above is not clear I want to find how many times Mr. A had sold Banana in the month of January?

Is there is any way to find countif with multiple criteria? Please do not suggest countifs

Appreciate your help in this regard.

Dear Jeff,

Thanks for your kind and quick reply, but this gives answer ZERO (0)

I've used your advised formula to calculate amount of sales these sales person done, but now I also want to count or calculate number of sales they have done so I can make an idea that how much revenue they did by doing how many number of sales and for that I was thinking to if I could find any way to count serial numbers by using countif or counta formula with multiple criteria.

Appreciate if you could assist me on that?

Thanks in advance!!

Please attach your file.

Here you go..... I've prepared a test file for you to review.

Thanks a lot for the assistance!!!

You're welcome! Thanks for the rep, and thanks for marking your thread Solved!