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

I juts tried it and it worked fine.

--

HTH

Bob

"Peter" wrote in message
...
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.

--
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.
--
Peter


"Bob Phillips" wrote:

I juts tried it and it worked fine.

--

HTH

Bob

"Peter" wrote in message
...
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.

--
Peter


.

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

--

HTH

Bob

"Peter" wrote in message
...
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.
--
Peter


"Bob Phillips" wrote:

I juts tried it and it worked fine.

--

HTH

Bob

"Peter" wrote in message
...
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.

--
Peter


.