Excel count cells where the cell on the left isn't empty

I'd like to count the amount of rows where the cell in column D is "Notebook" and the value of the respective cell of column C isn't empty. I tried countif but I couldn't figure out how it works properly. This is what the table looks like.

Thank you for your help.

Upvotes: 0

Views: 44

Answers (1)

user4039065
user4039065

Reputation:

try,

=countifs(d:d, "notebook", c:c, "<>")

Upvotes: 1

Related Questions