I am trying to figure this out in a formual and any help would be nice. Thanks.
If A03:A5000 = January And BC03:BC5000 = 1 then count how many 1's there are and return that value and if there is no 1's leave blank
This forum has been moved to TeachExcel.com
Ask all future questions in the New Excel Forum.
ExcelKey
=COUNTIFS(A3:A5000,"January",BC3:BC5000,1)
Return to General Excel Questions
Users browsing this forum: No registered users and 242 guests