Hello, I need to pull together a table of statistics in excel. I've used 48 COUNTIFS to count the entries I need but I was hoping somebody might be able to advise me how to do this with a more simplified formula.
The formula is: =COUNTIFS(Report!D:D,C5,Report!B:B,$D$4,Report!N:N,Trans_Description!$B$3)+COUNTIFS(Report!D:D,C5,Report!B:B,$D$4,Report!N:N,Trans_Description!$B$3)+COUNTIFS(Report!D:D,C5,Report!B:B,$D$4,Report!N:N,Trans_Description!$B$4)+.....COUNTIFS(Report!D:D,C5,Report!B:B,$D$4,Report!N:N,Trans_Description!$B$49)
The third criteria will be within this range: Trans_Description!$B$3:Trans_Description!$B$49
Is there a way I can specify a range of values as one of the criteria?
Any help would be appreciated!
The formula is: =COUNTIFS(Report!D:D,C5,Report!B:B,$D$4,Report!N:N,Trans_Description!$B$3)+COUNTIFS(Report!D:D,C5,Report!B:B,$D$4,Report!N:N,Trans_Description!$B$3)+COUNTIFS(Report!D:D,C5,Report!B:B,$D$4,Report!N:N,Trans_Description!$B$4)+.....COUNTIFS(Report!D:D,C5,Report!B:B,$D$4,Report!N:N,Trans_Description!$B$49)
The third criteria will be within this range: Trans_Description!$B$3:Trans_Description!$B$49
Is there a way I can specify a range of values as one of the criteria?
Any help would be appreciated!