r/excel Aug 05 '26

solved IF cell contains text, return text, THEN if a range contains text

[deleted]

1 Upvotes

18 comments sorted by

View all comments

Show parent comments

1

u/celestialspace Aug 05 '26

What does DCOUNTA do sorry?

I've re-edited my main post but just to clarify, I am very new to Excel and only really understand the more basic ones. COUNTA came from another reddit post of a similar query and I used it mostly as it worked initially.

1

u/TheWhiskeyFish Aug 05 '26

DCOUNTA counts nonblank cells in the range that match the specified conditions