Evening,
I'd appreciate any help on a formula for 2010, for this problem please:
I would like to check the number of time B5 is in column A, if D5 is in column C.
Thanks for any help you can give.
Evening,
I'd appreciate any help on a formula for 2010, for this problem please:
I would like to check the number of time B5 is in column A, if D5 is in column C.
Thanks for any help you can give.
Have a look at the COUNTIFS function.
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
=COUNTIFS(A:A,B5,C:C,D5)
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks