F
Father Guido
Guess I wasn't clear enough in my previous post. Hopefully this
will help.
I have a number of columns in a report, for simplicity I'll
just list the four I need below with my formula, which doesn't
work and returns a value of 0.
{=SUM(($F$2:$F$500="Ready to Verify")*($M$2:$M$500=$Z$1)*
($N$2:$N$500="TF")*($O$2:$O$500<>"*vortex*))}
By the way, Z1 = 12.1
F M N O
1 Ready to Verify 12.1 TF Vortex 12.1 not enabled
2 Ready to Verify 12.1 TF Product Test:Vortex Sanity Tests3
3 Ready to Verify 12.1 TF Power Palette: Test Setting
In the above small sample, I want to get an answer of 1. Cells
F3, M3, and N3 match the first 3 criteria AND cell O3 DOESN'T
contain the word vortex anywhere within it.
Rows 1 & 2 also meet the first 3 criteria, but their cells in
column O do have the word vortex somewhere within them, which
should invalidate the entire row and be treated as 0 from my
counting array point of view.
Thanks in advance!
Norm
will help.
I have a number of columns in a report, for simplicity I'll
just list the four I need below with my formula, which doesn't
work and returns a value of 0.
{=SUM(($F$2:$F$500="Ready to Verify")*($M$2:$M$500=$Z$1)*
($N$2:$N$500="TF")*($O$2:$O$500<>"*vortex*))}
By the way, Z1 = 12.1
F M N O
1 Ready to Verify 12.1 TF Vortex 12.1 not enabled
2 Ready to Verify 12.1 TF Product Test:Vortex Sanity Tests3
3 Ready to Verify 12.1 TF Power Palette: Test Setting
In the above small sample, I want to get an answer of 1. Cells
F3, M3, and N3 match the first 3 criteria AND cell O3 DOESN'T
contain the word vortex anywhere within it.
Rows 1 & 2 also meet the first 3 criteria, but their cells in
column O do have the word vortex somewhere within them, which
should invalidate the entire row and be treated as 0 from my
counting array point of view.
Thanks in advance!
Norm