Home |
Search |
Today's Posts |
#1
|
|||
|
|||
pleas help: sumproduct function returns #value or #ref error
hi all,
I'm trying to make a summary sheet for my inventory sheet that will tell me the total #of product (types a, b, c...) produced in a certain month. My inventory sheet looks something like this: Month Product 1 a 1 a 1 b 2 a 3 a 3 c For my summary, say I want to enter the month of interest in cell c1. So, if I'm interested in month 1, the cell in which my formula is in will spit out 3 as the total number of product produced. I tried both =sumproduct((month(b2:b6)=c1)*1) and =sumproduct((a2:a6(b2:b6)=c1)*1) which give me #value and #ref errors, respectively. What am I doing wrong? Is there another formula I could try? COUNTIF does not work because I have 3 parameters. If you have any suggestions, please type out an example for me that works. Thanks in advance. |
#2
|
|||
|
|||
=countif(A2:A100,C1)
-- HTH Bob Phillips "Jennie" wrote in message ... hi all, I'm trying to make a summary sheet for my inventory sheet that will tell me the total #of product (types a, b, c...) produced in a certain month. My inventory sheet looks something like this: Month Product 1 a 1 a 1 b 2 a 3 a 3 c For my summary, say I want to enter the month of interest in cell c1. So, if I'm interested in month 1, the cell in which my formula is in will spit out 3 as the total number of product produced. I tried both =sumproduct((month(b2:b6)=c1)*1) and =sumproduct((a2:a6(b2:b6)=c1)*1) which give me #value and #ref errors, respectively. What am I doing wrong? Is there another formula I could try? COUNTIF does not work because I have 3 parameters. If you have any suggestions, please type out an example for me that works. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct function returns #value or #ref error | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
Sumproduct function not working | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |