Count/

E

Edgar Thoemmes

=SUMPRODUCT((ZPODetails!V2:V18172<>"")*(LEFT(ZPODetails!A2:A18172,4)="3000"))
 
B

Bob Phillips

and the question is?

--
HTH

Bob Phillips

=SUMPRODUCT((ZPODetails!V2:V18172<>"")*(LEFT(ZPODetails!A2:A18172,4)="3000")
)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count the remaining weekdays in a data range excluding holidays and start/end dates 5
Section and Page numbering 0
Count w/ multiple variables & text values 5
sumproduct by year 2
Whole month total vice daily 2
Avoiding redundant calculations 7
How to count the numbers in a Word document? 0
Formulas Still Not Working 5

Top