Share via

SUMIF NOT ADDING ALL VALUES

Anonymous
2023-08-23T07:57:09+00:00

Please can someone help me.

In C3 & D3 I have currency values but I only want them to SUM in Cell I3 if F3 is a certain value so the formula I have is:

=SUMIF(F3,"*CK",C3:D3)

For some reason the value in I3 (where my formula is) is only showing what I have in C3 it is not adding C3 & D3 together I cannot see what is wrong with the formula?

I have also tried =SUMIF(F3,"*CK",(C3:D3)) but provided the same results.

Microsoft 365 and Office | Excel | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2023-08-23T08:30:57+00:00

Hey there, my name is Ajibola and I'm excited to help you out today!

It looks like you're trying to use the SUMIF function to sum values in the range C3:D3 based on a condition in cell F3. However, the SUMIF function isn't designed to handle ranges like C3:D3 directly within the formula. You can achieve your desired result by using the following approach: In cell I3, you can use the following formula to sum the values in C3 and D3 if the value in F3 matches the condition:

=IF(F3="*CK", C3+D3, "")

If you have any further questions or need additional assistance, please feel free to ask. I'm here to help!

If the reply was helpful, please don’t forget to upvote or accept it as an answer, Thank you

Kind regards

Was this answer helpful?

1 person found this answer helpful.
0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest