Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there anyway
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|