B
bryan.delara
For some reason I don't see this post on my screen. it has sorta got
lost, It's weird.
sorry if it is duplicated.
I use this formula
=SUMPRODUCT(--(E6:E2036=1),--(E7:E2037<>1),--($A6:$A2036>=TODAY
()-365)) to
count which works great, this counts 1's. I now need to add a P or a
UP to
the same cell as the 1. Is there anyway I can leave the formula above
as it
is and also do a count on the P or UP? Not all cells will have the
same
contents. I've tried using an array
=--{SUM(LEN(A8:A15)-LEN(SUBSTITUTE(A8:A15,"pl","")))/LEN("pl")} along
with
the sumproduct formula to count both, but with no joy. I've tried all
manor
of ways, all with the same results. Can anyone guide me please.
Bryan.
lost, It's weird.
sorry if it is duplicated.
I use this formula
=SUMPRODUCT(--(E6:E2036=1),--(E7:E2037<>1),--($A6:$A2036>=TODAY
()-365)) to
count which works great, this counts 1's. I now need to add a P or a
UP to
the same cell as the 1. Is there anyway I can leave the formula above
as it
is and also do a count on the P or UP? Not all cells will have the
same
contents. I've tried using an array
=--{SUM(LEN(A8:A15)-LEN(SUBSTITUTE(A8:A15,"pl","")))/LEN("pl")} along
with
the sumproduct formula to count both, but with no joy. I've tried all
manor
of ways, all with the same results. Can anyone guide me please.
Bryan.