Use COUNTIFS
Hence,
=COUNTIFS(A:A,"#N/A",E:E,G2)
where G2 equals 'IN'
Adapt for the others
Use COUNTIFS
Hence,
=COUNTIFS(A:A,"#N/A",E:E,G2)
where G2 equals 'IN'
Adapt for the others
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks