COUNTIFS Function

[Tikey]

I am using the following formula to count the number of occurences of a date so long as a value in a corresponding column is >0.


=COUNTIFS(Records!$F$2:$F$40000,">=1992-1-1",Records!$F$2:$F$40000,"<1993-1-1",Records!$I$2:$I$40000,">0")

This works fine, but I wish to expand the range which needs to be >0 to include a further 2 columns - Records!$I$2:$K$40000. If I do this I get a #VALUE ! error.

Can anyone offer a soultion to this, any help appreciated.

 

[JoeMo]

Cheers, that's now working, thank you for all your time and effort on this.

You may be a little older, but you still know a lot.

You are welcome - thanks for the reply.