Skip to main content

/ academic technology/ Group items tagged equivelent

Group items tagged

Filter: All | Bookmarks | Topics Simple Middle

Equivelent of "COUNTIFS" function in excel - Google Docs Help - 0 views

www.google.com.tw/...thread

excel equivelent countifs google spreadsheets google spreadsheets web2.0

shared by Matthew Ragan on 27 May 11 - No Cached

Matthew Ragan on 27 May 11

I am trying to count cells based on multiple criteria from multiple cell ranges using google docs. In Excel the formula is simply: =COUNTIFS(S2:S26, "IN", E2:E26, "A") This would select all of the cells with the word "IN" and the Letter "A" in the same corresponding row. Can anyone help me figure out a workaround for not being able to use the "countifs" function in google spreadsheet?

<div class="cArrow"> </div><div class="cContentInner">I am trying to count cells based on multiple criteria from multiple cell ranges using google docs. In Excel the formula is simply: =COUNTIFS(S2:S26, "IN", E2:E26, "A") This would select all of the cells with the word "IN" and the Letter "A" in the same corresponding row. Can anyone help me figure out a workaround for not being able to use the "countifs" function in google spreadsheet? </div>

...

Cancel

1 - 1 of 1

Showing 20▼ items per page

Related searches