| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
CountIf functions
Afternoon all.. I wondered if you could maybe help me.. I am trying to create a formula that will check the content off one colum and if this reads 'closed' then will add the value in a second colum. e.g A B 7 closed 1 open 2 closed 4 closed 5 open So if colum B = closed it will add the vaule of colum A. so total is 7+2+4 = 13 How can i do this? many thanks James -- themax16 ------------------------------------------------------------------------ themax16's Profile: http://www.excelforum.com/member.php...o&userid=23622 View this thread: http://www.excelforum.com/showthread...hreadid=437982 |
|
#2
|
|||
|
|||
|
themax16 Wrote: Afternoon all.. I wondered if you could maybe help me.. I am trying to create a formula that will check the content off one colum and if this reads 'closed' then will add the value in a second colum. e.g A B 7 closed 1 open 2 closed 4 closed 5 open So if colum B = closed it will add the vaule of colum A. so total is 7+2+4 = 13 How can i do this? many thanks James This formula =SUMIF(B1:B5,\"CLOSED\",A1:A5) will work for you. Regards. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=437982 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Functions IF, AND, COUNTIF, MATCH | Excel Worksheet Functions | |||
| COUNTIF and Nested Functions? | Excel Worksheet Functions | |||
| COUNTIF functions | Excel Worksheet Functions | |||
| How do I combine COUNTIF and AND functions in Excel | Excel Worksheet Functions | |||
| Is there a way to test color formatting in countIF functions? | Excel Worksheet Functions | |||
Linear Mode
