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


No comments:

Post a Comment