# SUMIFS help

P

#### Peter

Hi. Hope youâ€™re able to help. Iâ€™m having difficulties the SUMIFS function.
Either Iâ€™m using it incorrectly or perhaps itâ€™s the wrong function for me!

Iâ€™m trying to total the money amounts in column E as long as conditions in
columns A (cell A6 in this example) and column H are True. However, Iâ€™m
finding that the function is not totalling up the money amounts it should be
totalling in column E. Instead, itâ€™s just returning a single money amount in
column E and ignoring the rest! This is the function as Iâ€™ve written it:

=SUMIFS(BnkChqs!E3:E1000,BnkChqs!A3:A1000, A6,BnkChqs!H3:H1000,"*102")

So, Iâ€™m trying to add-up any money amounts in column E as long as the
condition in column A (cell A6 in this example) is true and column H contains
102.

Iâ€™m not sure if this helps, but I do have another column (column D) that
names each unique cheque number. Just thought Iâ€™d let you know that in case
Iâ€™m confusing the function in some way and it might expect some form of
uniqueness.

B

#### Bob Phillips

I juts tried it and it worked fine.

P

#### Peter

Hello Bob
I'm so grateful you took the time to look at this. The fact that it worked
for you made me re-visit my sheet. I discovered an error I had introduced
myself in a related formula! So, many thanks for the sanity check. All
fixed now.
cheers again.

B

#### Bob Phillips

Thanks for that Peter. I have often wondered whether such responses are
worthwhile, you have encouraged me