So I currently have this formula in a cell: =SUMIF(F4:F66,"Won",H4:H66)
In Column F I have the status of an opportunity. In Column H I have the value of said opportunity.
The above formula tells me the Sum of those opportunities with a status of “Won”. However, rather than a Sum of the values, I want a Count of the number with status “Won”.
How do I do that? COUNTIF AND COUNTIFS don’t seem to want to work. Any ideas?
I'm not really sure from your description what column H is actually for, but if you just want a count of the number of "wins", you would only need to refer to column F anyway (if column F is where the "won" status is recorded).
So COUNTIF really should work: COUNTIF(F4:F66,"Won")
Thanks for the reply rinks. I perhaps need to explain myself better. I get what you're saying above though, and it makes sense.
Essentially I've got a spreadsheet of opportunities; opportunities on the rows, details about them in the columns.
Column F shows the status of an opportunity (pending, won, etc) and columns H onwards show months, with values in each row for how much each opportunity is worth (and therefore how much will be brought in that month).
What you've said above would work for historic months, as the only items left in those columns will be "Won" (anything not won gets moved into the next month). So with that I could quickly see how many wins there were in October, say.
The problem is that for the current month, there's a mixture of won/pending/whatever, and I only want to count the wins in that month. I can do a Sum of the wins, and assumed I'd be able to do a count just as easily, but it doesn't seem to work like that, unless I'm missing something obvious.
Just checking I've got this right: you want to count how many rows have a status of "Won" in column F, and have a positive numeric value in column H? If that's the case, this should work: