Thread: Question
View Single Post
 
Reply
Posted 2017-04-02, 10:54 AM in reply to Kazilla's post starting "https://docs.google.com/spreadsheets/d/1..."
In sheets, you can actually setup a formula to test both conditions and accumulate, but it's been too long. The simplest solution is to add a column that evaluates to one if the required conditions for the row are met, and zero otherwise, then sum. There are various ways to import different data sets so you could do this in one book
Old
Profile PM WWW Search
WetWired read his obituary with confusionWetWired read his obituary with confusionWetWired read his obituary with confusionWetWired read his obituary with confusion
 
 
WetWired