Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Request for Help with Count Formula
I am trying to write a formula that tells me how many from
Ghana were Invalidated (Answer=4) In other words, count column A only if it is "Ghana", and only if column B is also "invalidate" Column A Column B Brazil Validate Bulgaria Invalidate Bulgaria Invalidate Bulgaria Invalidate Bulgaria Invalidate Bulgaria Validate Bulgaria Invalidate Bulgaria Validate Ghana Invalidate Ghana Invalidate Ghana Invalidate Ghana Invalidate Ghana Validate Greece Validate Greece Invalidate Thank you in advance for any help or advice! Jennifer |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Request for Help with Count Formula
=SUMPRODUCT((A1:A15="Ghana")*(B1:B15="Invalidate") )
Alan Beban Jennifer wrote: I am trying to write a formula that tells me how many from Ghana were Invalidated (Answer=4) In other words, count column A only if it is "Ghana", and only if column B is also "invalidate" Column A Column B Brazil Validate Bulgaria Invalidate Bulgaria Invalidate Bulgaria Invalidate Bulgaria Invalidate Bulgaria Validate Bulgaria Invalidate Bulgaria Validate Ghana Invalidate Ghana Invalidate Ghana Invalidate Ghana Invalidate Ghana Validate Greece Validate Greece Invalidate Thank you in advance for any help or advice! Jennifer |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Request | Excel Worksheet Functions | |||
formula request.... | Excel Discussion (Misc queries) | |||
Formula request | Excel Discussion (Misc queries) | |||
IF AND FORMULA REQUEST | Excel Discussion (Misc queries) | |||
Formula help request | Excel Discussion (Misc queries) |