Google Spreadsheet Post #2492
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI Aug-18-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