Another formula question

ashdrap

Hi,

I was trying to do a count for how many fire drills in each month. I have already done helpers for monthly and have a separate column for fire drills. This is the formula I have, can anyone help?

Victoria_Indimar

Hello! You would need to use the COUNTIFS since you're checking for two pieces of criteria.

Please try: =COUNTIFS(Monthly:Monthly,status@row,[Fire Drill]:[Fire Drill],true)

Or since it looks like you have references: =COUNTIFS({Monthly},status@row,{Fire Drill},true)

Hope this works. Please let us know!

Victoria_Indimar

Hello! You would need to use the COUNTIFS since you're checking for two pieces of criteria.

Please try: =COUNTIFS(Monthly:Monthly,status@row,[Fire Drill]:[Fire Drill],true)

Or since it looks like you have references: =COUNTIFS({Monthly},status@row,{Fire Drill},true)

Hope this works. Please let us know!

ashdrap

WONDERFUL!! Thank you!!! It worked!