Michaela K
New Member
- Joined
- Oct 18, 2022
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
Hello,
I'm trying to create frequencies table that will calculate frequency at baseline, during treatment and during follow-up. (please see snapshot below).
The formula is as follows in the "Frequency at Baseline" and works great:
=FREQUENCY(IF('Vitals - baseline_dosing_FU'!E:E = "Single Dose-D1",'Vitals - baseline_dosing_FU'!P:P), Vitals_Frequencies!B2:B7),
But, when I change the equal sign to <>, it also counts blank cells.
I've tried AND(NOT(ISBLANK) but I still don't seem to be getting what I want as, for a change, I'm getting everything as 0, which is not true:
=FREQUENCY(IF(AND(NOT(ISBLANK('Vitals - baseline_dosing_FU'!E:E)), 'Vitals - baseline_dosing_FU'!E:E <> "Single Dose-D1"), 'Vitals - baseline_dosing_FU'!P:P, ""), Vitals_Frequencies!B2:B7).
What I want to say is that I want the function to only count those frequencies where !E:E <> "Single Dose-D1" but not count blank cells.
Unfortunately, I don't seem to be getting the syntax right and in all honesty, I'm not a pro when it comes to excel formulas.
Can anyone advise?
I'm trying to create frequencies table that will calculate frequency at baseline, during treatment and during follow-up. (please see snapshot below).
The formula is as follows in the "Frequency at Baseline" and works great:
=FREQUENCY(IF('Vitals - baseline_dosing_FU'!E:E = "Single Dose-D1",'Vitals - baseline_dosing_FU'!P:P), Vitals_Frequencies!B2:B7),
But, when I change the equal sign to <>, it also counts blank cells.
I've tried AND(NOT(ISBLANK) but I still don't seem to be getting what I want as, for a change, I'm getting everything as 0, which is not true:
=FREQUENCY(IF(AND(NOT(ISBLANK('Vitals - baseline_dosing_FU'!E:E)), 'Vitals - baseline_dosing_FU'!E:E <> "Single Dose-D1"), 'Vitals - baseline_dosing_FU'!P:P, ""), Vitals_Frequencies!B2:B7).
What I want to say is that I want the function to only count those frequencies where !E:E <> "Single Dose-D1" but not count blank cells.
Unfortunately, I don't seem to be getting the syntax right and in all honesty, I'm not a pro when it comes to excel formulas.
Can anyone advise?