Thank you so much, I was trying the other way around nesting the SUM(CountIf) in the Sumifs, no wonder it didn't work
I am trying to sum the items in Column C that corresponds only to Status (column A) "Firm Quote" and "Requote" and Sub Status (column B) "In Progress", the result should be 4000.
Status Sub Status items Budget On Hold 210 Requote In Progress 2,000 Firm Quote On Hold 585 Firm Quote In Progress 500 Requote In Progress 1,500 Firm Quote On Hold 2,406 Requote On Hold 2,141 Budget In Progress 1,200 Total 4,000
Thank you so much!
I need to count how many calls are made each day based on that date occurrence in a cell with comments.
Is there a formula I could add in column E to show the results that I manually pasted please?
Or is there a way to count how many comments there are on a particular date?