Count IF

New Contributor



Here what I need to do :

On B1, formula that allows me to get a total as soon as as CONFIRMED is mention on the column B.

If column B is on confirmed, total of all K column


Any one can help ?







8 Replies


With your permission, I recommend to provide more information.

You'll get a quicker and more accurate answer, and those who want to help don't have to invest time guessing the problem.

I recommend: Always inform about your Excel version, operating system, storage medium/hard drive, OneDrive, Sharepoint, etc.).

If possible, add a file (without sensitive data) and use this file to describe your project step by step, or add photos with the appropriate description.

Don't forget that not every Excel user has a clue about every job and what you see he can't see.


In this link you will find some more information about it:

Welcome to your Excel discussion space!


Thank you for your understanding and patience



I know I don't know anything (Socrates)

@jpilard Not sure about your cell and column references but I guess that you want a formula in F1 that sums amounts from column K in case cells in column D ae equal to "CONFIRMED". If so, try this:






@Riny_van_Eekelen Thanks a lot,


What about if i have 2 criteria ?

@jpilard You may start by giving the complete picture. What second criteria?


Perhaps you can share your sheet via dropbox or something similar. Or, when you upload a screenshot, include the row and column headers so that it is clear how your schedule looks like and include examples of what you would want a formula to return in such examples.



With your help i have managed to get the overall amount based on criteria


CANCELAED 75,000.00


Now whatever is confirmed or Inquiry or Cancel I would like to get it breakdown per outlets




Thanks a lot,

@jpilard  Thanks! That helps. Then you'd need SUMIFS. See attached. I'll leave the formatting to you



Thanks a lot,

Very complicated to understand but it works.

Really appreciate

@jpilard Great! But then again, the set-up of your schedule isn't optimal.