View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gbpg gbpg is offline
external usenet poster
 
Posts: 58
Default sumproduct for multiple criteria in different columns

I have been trying to use this site to run a sumproduct formula for the below:

A B C D
E F G
projid status targetedstartdate targetedcompldate amountbilled
Onsched.


I want to count how many times the instances of a number with the prefix
B00000 or BPR000000 occur in column A (called projid) and when "Late" occurs
in column G (called Onsched.)

There are 4300 rows of data.

my formula is:
=SUMPRODUCT(A2:A4300="B*")*(G2:G4300="Late")

I don't get a sum of the values. Any ideas?