starrsuper
New Member
- Joined
- Feb 15, 2022
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hello Experts,
need a help i am having count value in Column A and respective strings in column B
need to find the total count value in Column A if the column B has starts with matching string.
used the below formula
=sumif(b2:b245,ACT*,A2:A245)
and got the result.
now i am having a string in J column and refence the cell value in the above formula but i cant use * symbol over there to match string.
suggestions much appreciated
=sumif(b2:b245,$j$2,A2:A245)
need a help i am having count value in Column A and respective strings in column B
need to find the total count value in Column A if the column B has starts with matching string.
used the below formula
=sumif(b2:b245,ACT*,A2:A245)
and got the result.
now i am having a string in J column and refence the cell value in the above formula but i cant use * symbol over there to match string.
suggestions much appreciated
=sumif(b2:b245,$j$2,A2:A245)