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 ...
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.
https://www.dropbox.com/scl/fi/3s9zlaetdpdsrc2orygj2/Events-Planner-2022-1.xlsx?dl=0&rlkey=v2jromw6kpougbc2rrmmgahxj
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,