mardi 21 juin 2016

How do I write a countifs function across multiple sheets that pulls from filtered data?

I am attempting to write a countifs function that populates data for my successful projects column. The data will be pulled from a separate page titled kickstarterscrape_06-02-201 with a filtered column.

/Users/jgirouard/Desktop/Screen Shot 2016-06-21 at 9.10.13 AM.png

The filtered column of the other sheet is titled status within column G, I would only like to pull data for successful projects. /Users/jgirouard/Desktop/Screen Shot 2016-06-21 at 9.15.15 AM.png

The current function that I have is..

=COUNTIFS('kickstarterscrape_06-02-201'!G:G="successful",Summary!B6)

However it returns an error. How do I write this correctly?

Aucun commentaire:

Enregistrer un commentaire