0

I have text in three columns and need to know how many times a particular name crops up

=SUM(COUNTIF(INDIRECT({"d6:d37","I6:I37","n6:n37"}),"peter"))

any ideas?

1
  • Welcome to Web Applications. While Excel and Google Sheets are similar apps, there are meny features that doesn't work the same way. Please add some sample data and the expected result to make it easier for others to better understand what the formula should do and verify that their proposals returns the expected result.
    – Rubén
    Apr 29 at 14:22

1 Answer 1

0

Both sum() and indirect() seem superfluous here. Use this simpler formula:

=countif( { D6:D37, I6:I37, N6:N37 }, "peter" )

1
  • Your formula solved my problem, thank you so much Apr 30 at 8:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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