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,
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