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...
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.
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...
Code:
=COUNTIF('Apr-06'!C:C,Summary!L13)
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.