Formua to only sum items where each item is less than 1.00

[Howardc1001]

I have values in Col I on sheet "PL Recon Items"


I only want to sum the values in Col I on sheet "PL recon Items" where the values are each under 1.00



I have set up a formula on sheet "Recon" in cell M2 but it is giving me an incorrect result. The total should sum 0.09

Please Login or Register  to view this content.

It would be appreciated if someone could amend my formula

[josephteh]

Try =SUMIF('PL Recon Items'!I2:I19,"<1")

[Glenn Kennedy]

As SUMIF is OK with whole column references, you can also use:

=SUMIF('PL Recon Items'!I:I,"<1")

[Howardc1001]

Thnks for the help Joseph & Glenn

[Howardc1001]

Hi Glenn & Joseph

I tried your formula using different samole data to sim values that are each below 1.00 which can be be up to to a maximum of -0.99 or 0.99

Mnually these sum to 0.09


Kindly test & amend your formula

[wk9128]

worksheet or Tab name : Recon

Cell M2 formula

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

[josephteh]

Try, =SUMIFS('PL Recon Items'!I:I,'PL Recon Items'!I:I,"<1",'PL Recon Items'!I:I,">-1")

[Howardc1001]

Thanks for the help, wk91028 & Joseph


Both your solutions give the correct result

[wk9128]

@Howardc1001 You're Welcome. Glad to help . Thank You for the feedback and rep.