Monday, February 26, 2018

yogi_Multi-Criteria Count In Sheet1!C8 From Table In DATA!A:C

Google Spreadsheet   Post  #2382

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Feb-26-2018

question by: stratanancy13
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/jznujQRpC9o;context-place=forum/docs

Counting cells based on specific criteria from multiple cells - help needed

Hello all,

I am stumped on this and really need help.

I have a spreadsheet pulling data into one tab from two other tabs.  I need to count number of cells in column C on the data tab, but only cells that that contain the word February in column C AND in column B contain National (which should be 7).  Spreadsheet example is via the link below.  See the cell highlighted yellow, and the associated comment


Your help is greatly appreciated!

Thank you!

Nancy