Count IF

[jpilard]

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,  

[#2]

@jpilard 

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

NikolinoDE

I know I don't know anything (Socrates)

[#3]

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

[#4]

@Riny_van_Eekelen Thanks a lot,

What about if i have 2 criteria ?

[#5]

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

[#6]

@Riny_van_Eekelen 

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,

[#7]

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

[#8]

Thanks a lot,

Very complicated to understand but it works.

Really appreciate

[#9]

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