# COUNTIFS 2 sheets, 2 columns each?

I have this formula that pulls all requests for February (well, every month, but lets start with February) from 2 sheets. But now I need it to also only pull the count for only the items that are also considered from "meetings" under the "type" column. Basically answering the question: how many of these line items happened in february and came from meetings?

This formula works but doesn't filter by type:

=COUNTIF([Request Date]:[Request Date], IFERROR(MONTH(@cell), 0) = 2) + COUNTIF({Completed Follow Ups Range 1}, IFERROR(MONTH(@cell), 0) = 2)

This one doesn't work but shows what I'm trying to do, but it doesn't work, any ideas what I'm doing wrong?

=COUNTIFS ([Request Date]:[Request Date],[type]:[type], FIND("meeting", @cell) IFERROR(MONTH(@cell), 0) = 2) + COUNTIF({Completed Follow Ups Range 1}, IFERROR(MONTH(@cell), 0) = 2)

• ✭✭✭✭✭✭

I'm not sure I"m following completely, but couldn't you do your COUNTIFS like this:

Parameter 1 = month (i.e., February)

Parameter 2 = type (i.e., Meetings)

=COUNTIFS([Request Date]:[Request Date], IFERROR(MONTH(@cell), 0) = 2, Type:Type, "Meeting") then add in your second sheet using the cell reference and probably doing COUNTIFS again

• ✭✭✭✭✭✭

I'm not sure I"m following completely, but couldn't you do your COUNTIFS like this:

Parameter 1 = month (i.e., February)

Parameter 2 = type (i.e., Meetings)

=COUNTIFS([Request Date]:[Request Date], IFERROR(MONTH(@cell), 0) = 2, Type:Type, "Meeting") then add in your second sheet using the cell reference and probably doing COUNTIFS again

• that worked!! I have no idea how I was messing that up so badly but thank you!!

• ✭✭✭✭✭✭

Glad to hear. Sometimes you just need to talk it out. A great start to your week. Go get 'em!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!