| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Can I count values in column 1 if criteria in column 2 are met
|
|
#2
|
|||
|
|||
|
=SUMPRODUCT(--(Range1<""),--(Range2=Condition)) confounded office user Wrote: -- Aladin Akyurek ------------------------------------------------------------------------ Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165 View this thread: http://www.excelforum.com/showthread...hreadid=276543 |
|
#3
|
|||
|
|||
|
On Tue, 9 Nov 2004 03:39:03 -0800, "confounded office user" <confounded office
wrote: COUNTIF --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If column A and column B have values how do i get the total in co. | Excel Discussion (Misc queries) | |||
| Count the text in a column - Part II | Excel Discussion (Misc queries) | |||
| How do I count the amount of text in a column and then add them | Excel Discussion (Misc queries) | |||
| How do I increment or decrement values in a column? | New Users to Excel | |||
| Count rows based on multiple criteria | Excel Worksheet Functions | |||
Linear Mode
