Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using SUMPRODUCT
I am using SUMPRODUCT to count mulitple criteria in different columns. It has
worked up to this point, but I am now getting a VALUE!error and am not sure why. Here is the scenario: 2 columns Month Type Jan A Jan B Feb A Feb B I need to count the error types by month. My fomula looks like this: =SUMPRODUCT(--(Month="Jan"),--(Type="A")) Month and Type are named ranges. I have also tried replacing the criteria with cell references. Thank you. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using SUMPRODUCT
Are the named ranges the same size i.e. number of rows? If not, this will
result in a VALUE! error. My limited testing worked OK using named ranges. HTH "Mondie Gonzales" wrote: I am using SUMPRODUCT to count mulitple criteria in different columns. It has worked up to this point, but I am now getting a VALUE!error and am not sure why. Here is the scenario: 2 columns Month Type Jan A Jan B Feb A Feb B I need to count the error types by month. My fomula looks like this: =SUMPRODUCT(--(Month="Jan"),--(Type="A")) Month and Type are named ranges. I have also tried replacing the criteria with cell references. Thank you. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using SUMPRODUCT
That was it. Thank you so much!
"Toppers" wrote: Are the named ranges the same size i.e. number of rows? If not, this will result in a VALUE! error. My limited testing worked OK using named ranges. HTH "Mondie Gonzales" wrote: I am using SUMPRODUCT to count mulitple criteria in different columns. It has worked up to this point, but I am now getting a VALUE!error and am not sure why. Here is the scenario: 2 columns Month Type Jan A Jan B Feb A Feb B I need to count the error types by month. My fomula looks like this: =SUMPRODUCT(--(Month="Jan"),--(Type="A")) Month and Type are named ranges. I have also tried replacing the criteria with cell references. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding "OR" to a Sumproduct Formula | Excel Worksheet Functions | |||
Need help with sumproduct & dynamic ranges | Excel Worksheet Functions | |||
Need help with sumproduct and dynamic ranges | Excel Worksheet Functions | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |