Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct error
I am using the following fomula below to calculate the sum of the number of
times the value of 1 is returned in cloumn g based on the conditions below. However it returns an error of #VALUE!. Column J contains employee ID's Column b contains a value of 1 if certain conditions are met Column G contains a value of 1 if certain conditions are met =SUMPRODUCT((('Employee Data'!$J$5:$J$260=$A33)*('Employee Data'!$B$5:$B$260=1)*('Employee Data'!$G$5:$G$260=1)*('Employee Data'!$G$5:$G$260))) Thanks ce |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT formula returning #VALUE! error | Excel Worksheet Functions | |||
Error Handler Not Working | Excel Discussion (Misc queries) | |||
DIV/0! error in SumProduct formula with no division | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
#REF error | Excel Worksheet Functions |