Hi all,
I was wondering if anyone can help me and apologies if I do not explain this very well.
I am trying to make an addition to an existing formula, to exclude a value from another sheet, but still count blanks.
Current formula under 'Total Perm' column on main sheet:
=IF(OR([Perm Promo]@row = "No available promo", [Max Perm]@row = "N/A"), "", COUNTIFS({Data(FI1006)-Home}, [Home Name]@row, {Data(FI1006)-Promo}, [Perm Promo]@row, {Data(FI1006)-Created}, >[Perm Promo Live]@row))
If successful, the 16 value should remain the same but the 2 value should reduce to 0 as these requests were not approved on the separate sheet.
Value I wish to exclude pulled from separate sheet and my attempted addition to the formula in bold, was set up as a sheet reference:
=IF(OR([Perm Promo]@row = "No available promo", [Max Perm]@row = "N/A"), "", COUNTIFS({Data(FI1006)-Home}, [Home Name]@row, {Data(FI1006)-Promo}, [Perm Promo]@row, {Data(FI1006)-Created}, >[Perm Promo Live]@row, {Data(FI1006)-FeeApprove}, <> "No"))
Essentially, I only wish to include values in the total that equal "Yes" or where the cell is blank in the 'Fee Approval' column, but exclude any "No" values from the total.
Please let me know what I'm missing or if this is even possible?
Thank you :)
