Forum Discussion
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
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)
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 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)
