ExcelBanter - When I use Sumif

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - When I use Sumif (https://www.excelbanter.com/excel-discussion-misc-queries/237791-when-i-use-sumif.html)

Clyde Dickson

When I use Sumif

WHEN I USE SUMIF IT APPEARS NOT TO RETURN THE CORRECT VALUE. IS THERE
SOMETHING THAT I AM DOING WRONG This is the formula I am using =SUMIF('[4
Jul 09 Report.xls]1 Jul'!$A$6:$A$980,A3,'[4 Jul 09 Report.xls]1
Jul'!$K$7:$K$980)

Many Thanks,

Eduardo

When I use Sumif

Hi,
at the end of your formula you have K7, change it for K6

"Clyde Dickson" wrote:

WHEN I USE SUMIF IT APPEARS NOT TO RETURN THE CORRECT VALUE. IS THERE
SOMETHING THAT I AM DOING WRONG This is the formula I am using =SUMIF('[4
Jul 09 Report.xls]1 Jul'!$A$6:$A$980,A3,'[4 Jul 09 Report.xls]1
Jul'!$K$7:$K$980)

Many Thanks,

All times are GMT +1. The time now is 03:13 AM.