Try this
=COUNTIF(Data!N2:Data!N2,"Y")+COUNTIF(Data!W2:Data!W2,"Y")+COUNTIF(Data!AA2:Data!AA2,"Y")+..........and so on
maybe this is what u want?
Azumi
Try this
=COUNTIF(Data!N2:Data!N2,"Y")+COUNTIF(Data!W2:Data!W2,"Y")+COUNTIF(Data!AA2:Data!AA2,"Y")+..........and so on
maybe this is what u want?
Azumi
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks