I have a set of data that I want to filter by both the rows and columns.

I want to create a function like FILTER(B4:L8, (B2:L2 = "Email")+(B2:L2 = "All"), A4:A8 = "Email") to filter the data in the image below. However this does not work, how would I go about this?

enter image description here

Example Google Doc: https://docs.google.com/spreadsheets/d/1JIGXmOKkb_llfnrfJmdbiwFG97tiL3E3PnDuhy3r9x8/edit?usp=sharing

1 Answer 1


As filter command documentation says,

In order to filter both rows and columns, use the return value of one FILTER function as range in another.

Like so:

=filter(filter(A4:L8, (A2:L2="Email")+(A2:L2="All")), A4:A8="Email")

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.