LinkBack URL
About LinkBacks
How do you count true values in a column but allowing for filtered data. I tried using sum product but I think you must need numerical data! Any help will be much appreciated.
How do you count true values in a column but allowing for filtered data. I tried using sum product but I think you must need numerical data! Any help will be much appreciated.
Probably something like this:
Please Login or Register to view this content.
where B1:B100 is the original range holding the TRUE/FALSE values.
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.
Suppose you have data in F2:F100 this formula will count only the visible TRUEs after filtering
=SUMPRODUCT((F2:F100=TRUE)*SUBTOTAL(3,OFFSET(F2,ROW(F2:F100)-ROW(F2),0)))
Audere est facere
Sorry I couldn't get this to work....do all values in F2:F100 need to be either true or false??
No, the formula should just count TRUE values, the others can be anything as long as they aren't error values. Did you use the exact formula I suggested or a variation?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks