SUMIF formula

[Hoopsah]

Hi,

looking for a formula that will help me do a couple of Sums for region of values.

Attached is a spreadsheet where I have done a sumproduct to count the instances of a code, between 2 numbers, but in the next 2 tables I am looking for a code that will –

Table 1: If the code is in column A then cost in column D, (E then H, I then L and M then P) and copy this across the line, but only if it is between the 2 codes mentioned.

Table 2 - If the code is found anywhere along the line then give the total sum that is in column.

All help appreciated

[shrivallabha]

If I understand correctly then for Table 1:

In Cell V11 and then copy down:
=SUMIFS($D$2:$D$1439,$A$2:$A$1439,">="&$T11,$A$2:$A$1439,"<="&$U11)
You can build similar construct in the other 4 column.

I haven't understood your second requirement. Can you explain one expected result for say cell V20.

[Hoopsah]

Hi Shrivallabha

Works perfectly.

Using your code I simply amended the first argument to calculate the cost on the final line: =SUMIFS($Q$2:$Q$1439,$A$2:$A$1439,">="&$T11,$A$2:$A$1439,"<="&$U11)
ult,

Thanks for your help

Hoopsah :)

[Hoopsah]

Sorry about above,

The result changing the first argument to Column Q for total cost works perfectly,

Thanks for your help

Hoopsah

[shrivallabha]

That's great. Thanks for the feedback.