CODEWITHSUNDEEP
excelexcel-formula
MattS
MattS

Reputation: 21

Excel count based on values of 2 columns

I have an Excel 2007 (xlsx) spreadsheet which has a table within it. The table has a column for date and a column for completed. I would like to do a count where the Date is today or earlier and where completed is not "Y"

The syntax I have put together is:

=COUNTIFS(UnitClosures[Completed Y/N], "<>Y", UnitClosures[Dismantling Date],"=< F7")

Cell F7 contains today's date.

When I use this I get 0 back despite having multiple columns not set to completed with a date earlier than today.

How can I change the syntax of my formula to get it to work? Thanks!

Upvotes: 2

Views: 157

Answers (1)

barry houdini
barry houdini

Reputation: 46441

The final criterion syntax is wrong, F7 has to be outside the quotes and concatenated - try like this:

"=<"&F7

so formula becomes this:

=COUNTIFS(UnitClosures[Completed Y/N], "<>Y", UnitClosures[Dismantling Date],"=<"&F7)

Upvotes: 6

Related Questions