Hi assuming your purchase order is text, Months in A column, Purchase orders in B column,you can try this formula
Formula:
=COUNTIFS(A:A,"Jan",B:B,">''")
If purchase order is number,Formula:
=COUNTIFS(A:A,"Jan",B:B,">0")
Regards,
Sindhu
Hi assuming your purchase order is text, Months in A column, Purchase orders in B column,you can try this formula
Formula:
=COUNTIFS(A:A,"Jan",B:B,">''")
If purchase order is number,Formula:
=COUNTIFS(A:A,"Jan",B:B,">0")
Regards,
Sindhu
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks