| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum with multiple criteria using SUMPRODUCT | Excel Worksheet Functions | |||
| SumProduct With Multiple criteria | Excel Worksheet Functions | |||
| sumproduct 2 columns based on criteria in 3rd column | Excel Discussion (Misc queries) | |||
| multiple criteria in if or sumproduct | Excel Worksheet Functions | |||
| sumproduct using multiple criteria | Excel Worksheet Functions | |||
Threaded Mode
