SUMIF not working for selecting specific info

[lukesanborn]

I am trying to use SUMIF in excel 2003 to add up pounds of fruit that come from certain ranches. I am using multiple worksheets, and I can't seems to create the correct formula. This is what I have tried using

=SUMIF(Data!A:A,Data!C:C='01'!A:A,Data!F:F).

I want this to be in column B of the 01 worksheet, and I want to copy it down so that all cells in column B will calculate the total pounds of fruit being harvested from each ranchblock. Attached is a copy of the spreadsheet.Raw Data 01.xls

[dilipandey]

Hi lukeshanborn,

Welcome to the forum.

Suggest you to change the thread title to reflect the query you asked.. see the forum rules:-

http://www.excelforum.com/forum-rule...rum-rules.html

Regards,
DILIPandey

<click on below 'star' if this helps>

[vlady]

how about

Please Login or Register  to view this content.

****************
if you can position your ranchblock and pounds in same column for all tabs

you can use something like this..

create a list of the workbook then name it(named range) like "list"
then formula..

=SUMPRODUCT(SUMIF(INDIRECT("'"&list&"'!C1:C100"),">"&A2,INDIRECT("'"&list&"'!F1:F100")))

again all column should be same position...

column C will be for the ranchblock for all sheet
and column F is the pounds for all sheet..