New Contributor

Count IF

Hi,

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 ?

Thanks,

8 Replies

Re: Count IF

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.

Welcome to your Excel discussion space!

Thank you for your understanding and patience

NikolinoDE

I know I don't know anything (Socrates)

Re: Count IF

@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:

=SUMIF(D:D,"CONFIRMED",K:K)

Re: Count IF

@Riny_van_Eekelen Thanks a lot,

What about if i have 2 criteria ?

Re: Count IF

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

Re: Count IF

https://www.dropbox.com/scl/fi/3s9zlaetdpdsrc2orygj2/Events-Planner-2022-1.xlsx?dl=0&rlkey=v2jromw6k...

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

 CONFIRMED / PAID AED 265,000.00 INQUIERY AED 0.00 CANCEL AED 75,000.00

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

 PRIVILEGE CARNA FI'LIA SBAR

Thanks a lot,

Re: Count IF

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

Re: Count IF

Thanks a lot,

Very complicated to understand but it works.

Really appreciate

Re: Count IF

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