B
Bryan De-Lara
For some reason I don't see this post on my screen. it has sorta got lost,
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.
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.