Excel 2007 - Sum of value found in Column BT if value in Column D equal the criteria

chamdan

New member
Hi,

I tried the following formula but getting an error due to some of the rows are blank "Circular Reference"
HTML:
``=SUMIF(\$D:\$D,"="&INDIRECT("\$D"&ROW()+1),BT:BT)``

Is there a way to get the last row within a column and get the formula to work accordingly?

Regards,

Chuck

NBVC

Super Moderator
Staff member
Where exactly are you entering this formula?

What exactly are you expecting the formula to do?

chamdan

New member
Hi,

I have this formula in column BT and have from BT6 to n number of rows values and in Column D I have a contract number that can be repeated n number of times. So my objective is to be able sum up o\all the values related to that particular contract number and have the sum added in the Cell BT5.

Each time a new contract is listed a line is dedicated to sum up the value corresponding to that contract as the first listed row .

e,g:

Column Column
D BT
Contract # Total
123456789 \$500
123456789 \$100
123456789 \$100
123456789 \$100
123456789 \$100
123456789 \$100

234567890 \$250
234567890 \$125
234567890 \$125

Regards,

Chuck

NBVC

Super Moderator
Staff member
Try in BT5:

Code:
``=SUM(BT6:INDEX(BT:BT,ROW()+COUNTIF(D:D,D5)-1))``

you can then copy that cell to BT12 (the start of the next batch).

Last edited:

chamdan

New member
Thanks NBVC!

It works like a charm.

Regards,

Chuck