I'm using sumif in my formula and keep getting #value! error why?
formula: =sumif('Sheet2:Sheet4'!B1:B43,="Sales",'Sheet2:Sheet4'!A1:A43)
I'm using sumif in my formula and keep getting #value! error why?
formula: =sumif('Sheet2:Sheet4'!B1:B43,="Sales",'Sheet2:Sheet4'!A1:A43)
This link may help on how SUMIF works
http://www.contextures.com/xlFunctions01.html
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
You can't use 3D references with SUMIF. You could try:
=SUMPRODUCT(SUMIF(INDIRECT("'" & {"Sheet2","Sheet3","Sheet4"} & "'!B1:B43"),"Sales",INDIRECT("'" & {"Sheet2","Sheet3","Sheet4"} & "'!A1:A43")))[/code]
Richard
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks