1

I am having problems with the following formula in excel:

=counta(iferror(filter('Form Responses'!F:F, 'Form Responses'!F:F =A2)))

Basically Form Responses is a separate sheet, all i am trying to do is make this formula look at multiple columns and count the responses from all of those columns so Form Responses F, G, H,I and so on.

Can anyone help me in correcting this?

Regards

James

DarkAjax
  • 15,955
  • 11
  • 53
  • 65
JMoore809
  • 13
  • 3

1 Answers1

0

=COUNTIF('Form Responses'!F:F, "="& A2)

multiple Columns (until Column AA):

=COUNTIF('Form Responses'!F:AA, "="& A2)

Siphor
  • 2,522
  • 2
  • 13
  • 10