Countif with multiple parameters for the same range?

[Royser12345]

Hello,

I was wondering if I can somehow use multiple parameters for the same range with "COUNTIF"? I know we have countifs function for multiple parameters but I am just lazy to fill out same range for every parameter since I have many parameters. Tried to use array but looks like didn't work. I think I saw somwhere that you can indicate several parameters using COUNTIF with dates by "/" symbol. Is there anything like that for regular text (not dates)?
Thank you

[Ron Coderre]

We can only help if we know what your criteria are.
Can you post some sample data, the COUNTIF rules you want to implement, and the resulting count (based on the sample data)?

[pjwhitfield]

It depends on what your criteria is like, for instance if its text then it may be covered by a Regular expression, can you post some examples?

[Royser12345]

Exampleforforum2.xlsx

thanks for replies. I am attaching a spreadsheet. I need to count # of instances my parameters are met in the range. Thank you

[Pete_UK]

Put this in D2:

=COUNTIF(B:B,C2)

then copy down. Note that you have a lot more distinct entries than in your list in column C.

Hope this helps.

Pete

[Royser12345]

Pete, thanks a lot, however it has to be 1 cell formula. So my question was is there any way I can avoid using COUNTIFS specifying range every time for a new parameter and some how use all these parameters in COUNTIF formula specifying range only once? Tried to use array - didn't work.
Thanks

[Pete_UK]

Ah, right - put this array* formula in D2:

=SUM(COUNTIF(B:B,C2:C14))

*An array formula needs to be confirmed using Ctrl-Shift-Enter (CSE), rather than the usual <Enter>.

Hope this helps.

Pete

[Royser12345]

Thanks a lot, Pete, exactly what I need!

[Ron Coderre]

Try this regular formula:

Please Login or Register  to view this content.

Does that help?

[Royser12345]

it does, thanks, Ron!

[XOR LX]

Try this regular formula:

Please Login or Register  to view this content.

Does that help?

That won't work without CSE!

SUMPRODUCT would avoid array-entry, though.

Regards

[Pete_UK]

Thanks for the rep, Royser.

Pete

[Ron Coderre]

Oops! That's what I meant to post.