Forum Discussion
COUNTIFS for multiple ranges
Hi I'm struggling to complete this formula. I need to count to the total quantity of cells that have a value but only if they hit all 3 requirements. E.g. IF Column A says 'Douglas' an...
Try:
=sum( (A2:A1000="Douglas")*(B2:B1000>499)*( (C2:C1000<>"")+(D2:D1000<>"")+(E2:E1000<>"")+(F2:F1000<>"") >0) )