Only counting Cells that begin with 15 I\'m amending a spreadsheet that is embod

ID: 638890 • Letter: O

Question

Only counting Cells that begin with 15

I'm amending a spreadsheet that is embodies cells: A6:R857

I need to count the number of projects that match text in column F and begin with the number 15 in column N.

It is key that it only counts cells that start with 15 rather than just searching for 15 within the whole cell.

There is no set length of characters in my N column.

For example:

There are 5 total projects.

3 of which is named Blue.

of those 3, only 2 were created in 15.

So the total is 2.

If you give me an example, I should be able to edit the ranges.

Any information would be great!

I'm building this spreadsheet for my CEO.

Thank you !!

Hi..

Ok, I see the problem - with the heading of Forecast!N:N actually. Sorry about that

Try:

=SUMPRODUCT(--(Forecast!$F$2:$F$999=N5),--(IFERROR((LEFT(Forecast!$N$2:$N$999,2)*1),0)=15))

then CTRL+SHIFT+Enter

I have shortened the ranges to row2 to row999 just to make it a little quicker. You need to decide if N5 needs any anchoring.

Hope this works now.

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.