Countif "Incorrect Argument Set"

Conor

I can't understand why this formula doesn't work...

=COUNTIF([2022]1:[2022]11, [Deal Prob]1:[Deal Prob]11, "Green")

Heather Duff

@Conor ,

Are you trying to count the number of cells that in 2022 that have data in them and are marked green in Deal Prob, or are you trying to sum the data from the 2022 column for the Deal Prob column marked green?

To count the number of cells, you'd use: =COUNTIFS([2022]1:[2022]11, >0,[Deal Prob]1:[Deal Prob]11, "Green")

To sum the data, you'd use: =COUNTIFS([2022]1:[2022]11, [Deal Prob]1:[Deal Prob]11, "Green")

Let me know if this works for you!

Best,

Heather

Conor

@Heather Duff Yes! Thank you so much

Heather Duff

@Conor great! Glad it worked for you.