On 2002-10-21 05:43, Peter100 wrote:
Hi
Andrew yours worked a treat
Aladin it still included the blanks
Many thanks to you all
On 2002-10-21 16:25, Peter100 wrote:
Hi Again
I see your point about testing both ranges, but now Aladins example confuses me, surely there is only one occurence of 0 and LEFT
On 2002-10-21 00:26, Peter100 wrote:
I want to count two ranges a15:a74 and g15:g74 as long as the first range contains "YES" and the second range contains "YES"
can one combine multiple countif statements ?