Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif, countif, sumproduct?????
Hello,
I have two columns: Col C, yes, yes, no, yes, yes and Col D, yes, no, yes, yes, Yes. I want to count on col D if it says yes and the coresonding cell in Col C says yes. Thus I would like a formula to return a count of 3 for this example. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif, countif, sumproduct?????
{=SUM(IF((C1:C100="yes"),IF(D1:D100="yes",1,0)))} You would obviously substitute the C1:C100 and D1:D100 with the range you need. This is not case sensative -- nevi ------------------------------------------------------------------------ nevi's Profile: http://www.excelforum.com/member.php...o&userid=33238 View this thread: http://www.excelforum.com/showthread...hreadid=552861 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif, countif, sumproduct?????
You could leave out the IF statements (either way works, but with more
complex formulae you could have problems w/the 7 nested function limit using IF statements). {=SUM((F4:F7="yes")*(G4:G7="yes"))} or =SUMPRODUCT(--(F4:F7="yes"), --(G4:G7="yes")) "nevi" wrote: {=SUM(IF((C1:C100="yes"),IF(D1:D100="yes",1,0)))} You would obviously substitute the C1:C100 and D1:D100 with the range you need. This is not case sensative -- nevi ------------------------------------------------------------------------ nevi's Profile: http://www.excelforum.com/member.php...o&userid=33238 View this thread: http://www.excelforum.com/showthread...hreadid=552861 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Forget SUMIF, COUNTIF and VLOOKUP | Excel Worksheet Functions | |||
sumproduct vs. countif | Excel Discussion (Misc queries) | |||
Sumproduct, If, Sumif, Countif, Match?? | Excel Discussion (Misc queries) | |||
countif, sumif, sumproduct - I dont know which to use | Excel Worksheet Functions | |||
Which formula to use? countif, sumif, sumproduct | Excel Discussion (Misc queries) |