countif based on 2 sets of criteria?

[loopa1]

Hello..

I'm using a countif to return the number of times a value exists, fair enough, very straight forward.

This is my formula for completeness...

=COUNTIF('Apr-06'!C:C,Summary!L13)

However, there are two possible times that my lookup value can return the count, and I need these to be seperated.

For example...

Tariff A: 6 days = £40.00
Tariff B: 5 days = £40.00

For both tariffs, it's returing all of the £40.00's. I have calculated the duration in another column, so I can use 5/6 days as another filter/criteria.

So instead of returning a count of 1000 for both, how can I return a count of 350 for one, and 650 for the other (for example)??

Thanks.

 

[Aladin Akyurek]

Forget about CountIf and so on, and just specify the ranges and the conditions that must hold for those ranges...

 

[loopa1]

Sorry, I'm not following. Can you give me examples please.

I have about 14 sheets, each refer to one month. Within these months, each row contains the value (of the transaction) and I have calculated the duration of stay based on start and end dates.

Is there a way I can use both of these to seperate the data?