Sum if and Count if

[southwoman]

I have what i am sure is a simple problem.


I am working on. Below is a sumif formula that I am using.


SUMIF('[New Supply All.xls]Actual'!$GS$4:$GS$309,D3,'[New Supply All.xls]Actual'!$AL$4:$AL$309)


What I would like to do is count the above so the result returned is a count of the above rather than the sum


Any help given would be most appreciated.


Regards

 

[Luke M]

It sounds like you just need to drop the last argument and change the function.

=COUNTIF('[New Supply All.xls]Actual'!$GS$4:$GS$309,D3)