Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't get Sumproduct to work: Excel 2003
Hi, I've read lots of the answers on here and my query should be easy but I
really can't make my formula work! I need to count all the 1s in a column where they were previously 0s Example: May June 0 1 0 1 0 1 0 1 1 1 Expected result here would be 4 I have tried: =sumproduct(P6:P570="0")*(Q6:Q570="1") but I get a value error. I have checked and none of the cells contains text. I believe that excel will ignore cells with no data in so that shouldn't be the problem (I have included extra rows at the bottom of the formula to allow for growing data over months!) Any help would be most welcome as my head hurts!!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't get Sumproduct to work: Excel 2003
=SUMPRODUCT((P6:P570=0)*(Q6:Q570=1))
-- Gary''s Student - gsnu200902 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't get Sumproduct to work: Excel 2003
I am an idiot - you are a genius and I can now finish work.
Thank you very much indeed (am mildly embarrassed but still quite happy that you've sorted this for me!) "Gary''s Student" wrote: =SUMPRODUCT((P6:P570=0)*(Q6:Q570=1)) -- Gary''s Student - gsnu200902 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't get Sumproduct to work: Excel 2003
You are very welcome!
-- Gary''s Student - gsnu200902 "Emma C" wrote: I am an idiot - you are a genius and I can now finish work. Thank you very much indeed (am mildly embarrassed but still quite happy that you've sorted this for me!) "Gary''s Student" wrote: =SUMPRODUCT((P6:P570=0)*(Q6:Q570=1)) -- Gary''s Student - gsnu200902 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct in Excel 2003 | Excel Worksheet Functions | |||
Sumproduct in Excel 2003 | Excel Worksheet Functions | |||
SUMPRODUCT FORMULA EXCEL 2003 | Excel Worksheet Functions | |||
Array Doesn't work in Excel 2003 | Excel Worksheet Functions | |||
need to work across two sheets in excel 2003 | Excel Worksheet Functions |