LinkBack URL
About LinkBacks
Please provide formula to count with two conditions and to return blank for #N/A. Please see attached document. Thank you.
Please provide formula to count with two conditions and to return blank for #N/A. Please see attached document. Thank you.
Last edited by jewellove; 04-11-2013 at 09:21 AM.
Try COUNTIS and COUNTIFS formula. Eventually wrap into IFERROR
I have edited the attachment. I tried countif and countifs and I didn't get the right answer. Probably, this is a combination of vlookup. Vlookup for the company and count the number of M (male)..
Last edited by jewellove; 04-11-2013 at 09:57 AM.
hey jewellove, maybe in F11:
=IF(AND(A11<>A10;A11<>"");COUNTIF($A$11:$A$37;A11);"")
and G11:
=IF(AND(A11<>A10;A11<>"");COUNTIFS($A$11:$A$37;A11;$C$11:$C$37;"F");"")
change "F" to "M" if you need
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Yes!!! Thank you, Beni
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks