Hello,
Can someone please adjust formulas that are in G3:G6 and apply condition if 'Yes' in column C for formulas in the yellow area H3:H6 ?
Thank you kindly
Hello,
Can someone please adjust formulas that are in G3:G6 and apply condition if 'Yes' in column C for formulas in the yellow area H3:H6 ?
Thank you kindly
You can add that condition to your existing formulae like
=COUNTIFS(C$9:C$133,"Yes",$M$9:$M$133,">"&($A$3+14),$M$9:$M$133,"<="&($A$3+30))
Thank you very much that works great!
You're welcome & thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks