I am trying to write a formula in Excel to do the following:
Say I have a spreadsheet with 4,000 lines.
I need to gather counts based on certain/multiple criteria.
I need to count if:
B2 = FTIC
E2 = STU
F2 = 1 AND/OR G2 = WH
AN2 = 2011FA1
I just can't seem to figure this one out. I've tried both SUMPRODUCT AND COUNTIF but just can't seem to get it.
If someone can assist based on the example, I would GREATLY appreciate it.
As usual, thank you......this forum rocks!