Counting the value from one column only if it is in the future

Marcelo Maceira

Hi All,

I have 2 columns, one with Fuel systems, and another with the dates they have or will be delivered.

Looking at the snap shot below, what formula would I use to only count the entries of the fuel system column that contain "AGILITY" and that have a Del Date in the future?

Thanks

Malaina Hudson

Try this and see if it works for you.

=COUNTIFS([FUEL SYSTEM]:[FUEL SYSTEM], CONTAINS("AGILITY", @cell), [CNG Org Est Del to Chass/Body]:[CNG Org Est Del to Chass/Body],>=TODAY())

Malaina Hudson

Try this and see if it works for you.

=COUNTIFS([FUEL SYSTEM]:[FUEL SYSTEM], CONTAINS("AGILITY", @cell), [CNG Org Est Del to Chass/Body]:[CNG Org Est Del to Chass/Body],>=TODAY())

Marcelo Maceira

Worked like a charm! Thanks Malaina!

Malaina Hudson

@Marcelo Maceira Glad to help!