COUNTIFS with INDEX MATCH ?

Hello,

I have two tables one with quantity and another for $. I am trying answer a few questions and need help on the formulas to do so. Will require CountIF I think. Attached is the sample file. Please, help!

Your sample file has a list of several customers (I am assuming that A, B, C, etc., are supposed to be customer names).

Your question says, "Return first date Customer had a quantity greater than 0". There is only one space for a formula. Which customer is this formula supposed to be for?

Your question says, "# of customers that had first ever quantity by date" There is only one space for a formula. Which date?

Similar for all your other questions.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. Normally I would do this for you, however I am not clear what the main aim here is.)

Notwithstanding the poor thread title, which needs addressing (see above), we expect you to deal with one issue per thread here. Looking at your workbook, I cannot see what you have tried: all I see is a list of requirements. If you want someone else to do all the work for you, you should consider the Commercial Services section, where you can pay a forum member to take it on and produce all the formulae you need.

If you wish to continue here in the free forum you need to:

1. Be prepared to do some of the work yourself - tell us what you have tried and in what way it's not working for you.
2. Limit the number of major issues per thread to ONE.

Here are formulas for the first three things you needed, based on your first file.

Your descriptions are not clear enough for me to give you formulas for the rest. It would help if you would show, for each item, an example of the result you want, and explain how you got that result.

You are asking several questions, though they are all closely related and you are just asking for a handful of formulas rather than a total solution from scratch, so I answered more than one.

Sorry, I have no idea what you are trying to show in this file.

COUNTIFS(Data!$C$2:$C$14,Solve!B3,Data!$A$2:$A$14,Solve!A3,">0")

is invalid syntax; there must be an even number of arguments and you have 5. Also there is no sheet called Solve in this file. I don't know what you are trying to do with that formula.

"<< Answer should be 3" What is the question you are trying to answer? Why should the answer be 3?