Sarah,

you could cancatenate the both columns in another one and countif this new.
just a tip with an alternative, while we do not able to find another way.

regards
Marcelo - Brazil


"Sarah" escreveu:

Hi there
I have 2 columns of data. I want to ask Excel to look in column 1, determine
which rows match the condition, then look at column 2 and in those rows which
matched the condition, count how many have values in them i.e. exclude
blanks. Not sure how to build 2 conditions into a countif - any ideas??
Thanks!