try to use the following array function:
(array function end with Ctrl+Shift+Enter)

=COUNT(IF((($A$2:$A$8)="A")*(($B$2:$B$8)="A"),$C$2 :$C$8))

--
Best regards,
---
Yongjun CHEN
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download

"blake7" wrote in message
...
I want to use the countif function in excel to look at one criteria in one
column and another criteria in another before summing up, can this be done
?