Forum Discussion
Countifs function
Ok so I need to create a formula that does a couple of things I am not even sure if it is possible. I need to find a specific value in three different columns which I can do but I also need to pull d...
Jon,
jon mulkey wrote:
I need to show this for each fruit
Apples Total in sales = $130.00
Apples Total Credits = $10.00
Apples Total other Expenses = $20.00
Apples Total net sales = $100.00
these figures don't match the data in the table.
Use SUMIFS().