I need to count the rows only if these two conditions exist in the same row.
Column A must be a specific numerical value and column B must contain any
text.
Thanks...
I need to count the rows only if these two conditions exist in the same row.
Column A must be a specific numerical value and column B must contain any
text.
Thanks...
I assumed your range is row 1:100, change to fit your data:
=SUMPRODUCT(--(A1:A100=your_numerical_value),--(ISTEXT(B1:B100)))
--
Regards,
Dave
"Vegs" wrote:
> I need to count the rows only if these two conditions exist in the same row.
> Column A must be a specific numerical value and column B must contain any
> text.
> Thanks...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks