How to add name range to =SUM(COUNTIF(INDIRECT(...name range here...),"x"))

**chrispikekerry** · 07-26-2022, 12:38 PM

(using office 365) (Using Windows 10)
I am struggling to drop a name range into this formula

=SUM(COUNTIF(INDIRECT(...name range here...),"x"))

I am just trying to count how many "X"'s are in the Range... I want a range incase a row is added the range should expand... I hope .LOL

Help is much appreciated
Thanks

**JohnTopley** · 07-26-2022, 12:43 PM

Try

=COUNTIF(myRng,"x")

"myrng" is the named range

**Glenn Kennedy** · 07-26-2022, 12:44 PM

I don't understand why you want to use INDIRECT...

A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.

**chrispikekerry** · 07-26-2022, 01:37 PM

Hi Glen, My uploads are blocked. Let me try an clip
Attachment 789040

does this work?

It seemed to let me upload a png.....
Have to respect work security filters for sure.
Chris

**chrispikekerry** · 07-26-2022, 01:39 PM

Thank you John

How to add name range to =SUM(COUNTIF(INDIRECT(...name range here...),"x"))

LinkBack

Thread Tools

Rate This Thread

Display

How to add name range to =SUM(COUNTIF(INDIRECT(...name range here...),"x"))

Re: How to add name range to =SUM(COUNTIF(INDIRECT(...name range here...),"x"))

Re: How to add name range to =SUM(COUNTIF(INDIRECT(...name range here...),"x"))

Re: How to add name range to =SUM(COUNTIF(INDIRECT(...name range here...),"x"))

Re: How to add name range to =SUM(COUNTIF(INDIRECT(...name range here...),"x"))

Thread Information

Users Browsing this Thread

Similar Threads

Find MAX value from a range of time intervals displayed as "days", "hrs", "mins"

help with =SUMPRODUCT(COUNTIF(INDIRECT("'"&A25:A31&"'!L7:L30"),"<60")

VBA - Excel 2013 - WorksheetFunction.CountBlank

Receiving #REF when using max(indirect("cell referencing a named range")

How to check if a range of cells contains the word "unresponsive" and return "yes" or "no"

if Range("A1") = "Mike" Then Range("A1") = "michael" Then Exit Sub

Why does =countif(range,"<>""") count empty cells?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions