software

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 ?

No but you can use SUMPRODUCT,

assume you want to count values in A1: A10 that are greater than 5 and has
the colour red in B1: B10

=SUMPRODUCT(--(A1:A10gt;5),--(B1:B10=quot;redquot;))

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;blake7quot; gt; wrote in message
...
gt;I want to use the countif function in excel to look at one criteria in one
gt; column and another criteria in another before summing up, can this be done
gt; ?try to use the following array function:
(array function end with Ctrl Shift Enter)

=COUNT(IF((($A$2:$A$8)=quot;Aquot;)*(($B$2:$B$8)=quot;Aquot;),$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

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