COUNTIFS formula for multiple criteria referencing a formatted table

[jholiday78]

Hello,

I have never had a problem with this formula before, except now that I am using the same formula in a worksheet that references another worksheet formatted as a table in the same workbook. I could just be doing something wrong. Hopefully you are still following me. Not sure if this has anything to do with why my formula won't work, but the table is connected to a share point list that updates upon opening.

First: I need to count every cell in the column "Equipment Install Date" during the month of January.
Secondly: I need to only count the entries made that apply to the "host printers" in the "Element Title" column.

This is the formula I am using which doesn't bring back any values. What am I doing wrong?

=COUNTIFS(Table_owssvr[Equipment Install Date],">1/1/2015",Table_owssvr[Equipment Install Date],"<1/31/2015",Table_owssvr[Element Title],"=Host Printers")

*Note: "Table_owssvr" is the tab name that has connections to a Sharepoint list.
"Equipment Install Date" is the name of the column. For some reason it doesn't reference the range.

[quekbc]

Try this:
Change "=Host Printers" to "Host Printers"

[jholiday78]

I tried your suggestion above and that did not work. Any other suggestions?

=COUNTIFS(Table_owssvr[Equipment Install Date],">1/1/2015",Table_owssvr[Equipment Install Date],"<1/31/2015",Table_owssvr[Element Title],"Host Printers")

[Tony Valko]

Use cells to hold the date criteria:

A1 = 1/1/2015
B1 = 12/31/2015

=COUNTIFS(Table_owssvr[Equipment Install Date],">"&A1,Table_owssvr[Equipment Install Date],"<"&B1,Table_owssvr[Element Title],"Host Printers")

By using > and < you're excluding 1/1/2015 and 12/31/2015 from the count.

Did you mean >= and <= which will include all dates within the year 2015?

[jholiday78]

I think I figured it out. The column that had the install date in it also contained other text such as "TBD". I don't think the formula was recognizing it. I created another column with just the dates and it worked. See below my new formula.

=COUNTIFS(Table_owssvr[Install Date],">="&Formulas!R38,Table_owssvr[Install Date],"<="&Formulas!S38,Table_owssvr[Element Title],"=Host Printers")

[Tony Valko]

Good deal. Thanks for the feedback!

[jholiday78]

Hi Tony,

I put that formula in and there is no return of data. I have 1 entry (on 1/5/2015) for host printers in the column of Equipment Install date. I really think it has something to do with the table. I haven't ever created formulas from a formatted table before (the data is exported from a Sharepoint list). Could this be the issue?

=COUNTIFS(Table_owssvr[Equipment Install Date],">="&Formulas!R38,Table_owssvr[Equipment Install Date],"<="&Formulas!S38,Table_owssvr[Element Title],"Host Printers")

You are correct about >= and <= . Trying to capture what happened during the month of January. How many installs (Equipment Install Date) as it pertains to host printers (Equipment Title).