Friday, August 24, 2018

yogi_Multi Criteria Count -- Number Of Cars Available For Days As Specified From Data In Another Tab

Google Spreadsheet   Post  #2495

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

question by: Richie Mastria
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/sDDPYPlCXU4;context-place=forum/docs
How good are you at google sheets?
On summary page. Row BCG (A3). 3 days (B3).
I need a formula to calculate how many over 3 days and under 7 days excluding status "done".

The formula I have now to calulcate how many are over 3 days and under 7 is correct:
=countifs(BCGdays, ">3", BCGdays,"<7")

But unfortunately it counts ever one including ones that are done.

I need it to exclude BCGstatus (in name range) is "DONE".

Please help!

Thank you
Richie

No comments:

Post a Comment