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. |
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. |
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. |
All times are GMT +1. The time now is 02:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com