Hi. Hope youre able to help. Im having difficulties the SUMIFS function.
Either Im using it incorrectly or perhaps its the wrong function for me!

Im 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, Im
finding that the function is not totalling up the money amounts it should be
totalling in column E. Instead, its just returning a single money amount in
column E and ignoring the rest! This is the function as Ive written it:

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

So, Im 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.

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

--
Peter