I'm trying to count # of times a number (coded #) appears over a range (C:Z) in a given month of a given year. Sample data below. The only solution I could come up with was using COUNTIFS, but that only works to count one column at a time
=COUNTIFS(C:C,1,A:A,">="&AH1,A:A,"<"&AI1)
ideally I'd want
=COUNTIFS(C:Z,1,A:A,">="&AH1,A:A,"<"&AI1) which doesn't work
the only solution seems to be to do
=COUNTIFS(C:C,1,A:A,">="&AH1,A:A,"<"&AI1) + COUNTIFS(D:D,1,A:A,">="&AH1,A:A,"<"&AI1) until reaching Z:Z which is extremely redundant, specially since I want to do this over many numbers.
Any solution would be appreciated.
sample data:
=COUNTIFS(C:C,1,A:A,">="&AH1,A:A,"<"&AI1)
ideally I'd want
=COUNTIFS(C:Z,1,A:A,">="&AH1,A:A,"<"&AI1) which doesn't work
the only solution seems to be to do
=COUNTIFS(C:C,1,A:A,">="&AH1,A:A,"<"&AI1) + COUNTIFS(D:D,1,A:A,">="&AH1,A:A,"<"&AI1) until reaching Z:Z which is extremely redundant, specially since I want to do this over many numbers.
Any solution would be appreciated.
sample data: