Forum Discussion

Copper Contributor

Jul 16, 2021

Solved

COUNT IF FORMULA

Hello, I am trying to create a formula that could separate our credit cards incomes from the cash ones. In the excel file I put the price that the customer is paying, and the payment method. ...

Formulas and Functions

NikolinoDE
Jul 16, 2021
StepScoot

Here is an example added to your file.
Example in K19 & K20.

I would be happy to know if I could help.

NikolinoDE
I know I don't know anything (Socrates)

* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.
Trial_SUMIF.xlsx11 KB

NikolinoDE

Platinum Contributor

Jul 16, 2021

StepScoot

A picture does not help me personally, since i am not very fluent in the language either, want not to talk about the automatic translation :).

With your confidence, I recommend that you insert a file without sensitive data.

At the same time knowing the Excel version and the operating system would be an advantage.

Benefit for everyone, for you to get a quick and accurate answer and for the helpers to save time and also to help other users.

Here you will find some rules of the forum, quickly listed. It's worth taking a look.

Welcome to your Excel discussion space!

Thank you for your patience and understanding

NikolinoDE

StepScoot
Copper Contributor
Jul 16, 2021
NikolinoDEExcel 2003 at the moment with windows 10.

I also added the example file for you to check better.
Trial.xlsx10 KB
- NikolinoDE
  Platinum Contributor
  Jul 16, 2021
  StepScoot
  
  Here is an example added to your file.
  Example in K19 & K20.
  
  I would be happy to know if I could help.
  
  NikolinoDE
  I know I don't know anything (Socrates)
  
  * Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.
  Trial_SUMIF.xlsx11 KB
  - StepScoot
    Copper Contributor
    Jul 19, 2021
    Great. it worked perfectly!! Thank you very much!