Need help with a formula

DeMetria Hines

=COUNTIFS({Demand State}, [Primary Column]@row, {Investment Class}, "Grow", {Portfolio}, "P&C Claims", <=DATE(2023, 1, 1), {Demand Opened Date}, >=DATE(2023, 12, 31))

Can someone help me figure out why it's not working?

Leibel S

Then this should be your formula:

=COUNTIFS({Demand State}, [Primary Column]@row, {Investment Class}, "Grow", {Portfolio}, "P&C Claims", {Demand Opened Date},and(@cell>=DATE(2023, 1, 1), @cell <=DATE(2023, 12, 31)))

Leibel S

@DeMetria Hines

Not sure what you are trying to accomplish with the dates but you seem to be missing a {range} between "P&C Claims", and <=DATE(2023, 1, 1).

Is the below what you are looking for?

=COUNTIFS({Demand State}, [Primary Column]@row, {Investment Class}, "Grow", {Portfolio}, "P&C Claims", {Demand Opened Date},and(@cell<=DATE(2023, 1, 1), @cell >=DATE(2023, 12, 31)))

DeMetria Hines

I am trying to count how many times [Primary Column]@row, when the Investment class is Grow, the Portfolio is P&C Claims, and the Demand Opened Date is between 01/01/23 - 12/31/23.

DeMetria Hines

@Leibel S please see explanation above.

Leibel S

Then this should be your formula:

=COUNTIFS({Demand State}, [Primary Column]@row, {Investment Class}, "Grow", {Portfolio}, "P&C Claims", {Demand Opened Date},and(@cell>=DATE(2023, 1, 1), @cell <=DATE(2023, 12, 31)))

DeMetria Hines

Thank you! That worked!