Formula

✭✭

Im using this formula to count the total # of quotes by month but wanted to add an another formula based off of my check box being checked. This is the current formula that I'm using

=COUNTIF({Archived Installation Quote's Range 2}, IFERROR(MONTH(@cell), 0) = 1)

• Overachievers

You only need to use "COUNTIFS" at the beginning of your formula. Here's an example:

Number of Quotes Won in June =COUNTIFS([Date Quote Won]:[Date Quote Won], IFERROR(MONTH(@cell), 0) = 6, [Quote Status]:[Quote Status], "Won")

I made this a sheet summary formula, but you can replace the [ ]:[ ] ranges with your cross-sheet references.

• Overachievers

Hi @TPALJA , if you want to evaluate based on multiple criteria, you can use COUNTIFS instead.

• ✭✭

I tried using this =COUNTIFS({Date quote one}, IFERROR(MONTH(@cell), 0)=1), COUNTIFS({Quote Status}, "won" but it came back as unparseable

• Overachievers

You only need to use "COUNTIFS" at the beginning of your formula. Here's an example:

Number of Quotes Won in June =COUNTIFS([Date Quote Won]:[Date Quote Won], IFERROR(MONTH(@cell), 0) = 6, [Quote Status]:[Quote Status], "Won")

I made this a sheet summary formula, but you can replace the [ ]:[ ] ranges with your cross-sheet references.

• ✭✭

Julie, that did it! I cant thank you enough!

• Overachievers
• ✭✭

Julie, just when I think I had it. I did a test sheet like your example and it worked perfectly like your example, but when I pulled it from another sheet it came back as unparsable

I did

=COUNTIFS({Test sheet Range 1}:{Test sheet Range 1},IFERROR(MONTH(@cell), 0) =1,{Test sheet Range 2}:{Test sheet Range 2},"Won").

• Overachievers

Cross sheet references can encompass a whole column, so you don't have to list the reference twice. This should work:

=COUNTIFS({Test sheet Range 1}:{Test sheet Range 1},IFERROR(MONTH(@cell), 0) =1,{Test sheet Range 2}:{Test sheet Range 2},"Won").

=COUNTIFS({Test sheet Range 1},IFERROR(MONTH(@cell), 0) =1,{Test sheet Range 2},"Won").

• ✭✭

that worked! you made my day. I appreciate it!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!