LinkBack URL
About LinkBacks
Probably you can use Countifs...
e.g.
=COUNTIFS('Data Sheet'!B:B,$A$1,'Data Sheet'!L:L, "yes")/COUNTA('Data Sheet'!L2:L225)
you should probably be consistent with the ranges though... i.e either L:L or L2:L225 in both functions...
Probably you can use Countifs...
e.g.
=COUNTIFS('Data Sheet'!B:B,$A$1,'Data Sheet'!L:L, "yes")/COUNTA('Data Sheet'!L2:L225)
you should probably be consistent with the ranges though... i.e either L:L or L2:L225 in both functions...
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thanks for this:
=COUNTIFS('Data Sheet'!B:B,$A$1,'Data Sheet'!L:L, "yes")/COUNTA('Data Sheet'!L2:L225)
When I put it in, it 'works' but gives the wrong value. It could possibly be because it is looking for the value of A1 on the data sheet, rather than on the formula sheet. I tried to put in the 'reference' to the formula sheet, but it then doesn't work. I tried this:
=COUNTIFS('Data Sheet'!B:B,'Formulas'!$A$1,'Data Sheet'!L:L, "yes")/COUNTA('Data Sheet'!L2:L225)
Any ideas, please?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks