| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF formula problems
I have a range of data (example below) and I'm trying to identify every time
a row has both VTF and 1a in their respective columns. I've tried everything I can think of but I'm not getting the right answer (would be 1 in the example below). Please can anyone help?! Many thanks Caroline Example: column 1 column 2 column 3 ABC complete 1a VTF incomplete 1a VTF incomplete 2 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNTIF formula problems
Try this:
=SUMPRODUCT((A1:A100="VTF")*(C1:C100="1a")) adjust the ranges to suit. Hope this helps. Pete On Jan 29, 3:51*pm, CazzyP wrote: I have a range of data (example below) and I'm trying to identify every time a row has both VTF and 1a in their respective columns. *I've tried everything I can think of but I'm not getting the right answer (would be 1 in the example below). Please can anyone help?! Many thanks Caroline Example: column 1 * * *column 2 * * *column 3 ABC * * * * * * complete * * *1a VTF * * * * * * incomplete * *1a VTF * * * * * * incomplete * *2 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNTIF formula problems
Thanks very much Pete. I'll give that a go!
"Pete_UK" wrote: Try this: =SUMPRODUCT((A1:A100="VTF")*(C1:C100="1a")) adjust the ranges to suit. Hope this helps. Pete On Jan 29, 3:51 pm, CazzyP wrote: I have a range of data (example below) and I'm trying to identify every time a row has both VTF and 1a in their respective columns. I've tried everything I can think of but I'm not getting the right answer (would be 1 in the example below). Please can anyone help?! Many thanks Caroline Example: column 1 column 2 column 3 ABC complete 1a VTF incomplete 1a VTF incomplete 2 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNTIF formula problems
You're welcome.
Pete On Jan 30, 9:51*am, CazzyP wrote: Thanks very much Pete. *I'll give that a go! "Pete_UK" wrote: Try this: =SUMPRODUCT((A1:A100="VTF")*(C1:C100="1a")) adjust the ranges to suit. Hope this helps. Pete On Jan 29, 3:51 pm, CazzyP wrote: I have a range of data (example below) and I'm trying to identify every time a row has both VTF and 1a in their respective columns. *I've tried everything I can think of but I'm not getting the right answer (would be 1 in the example below). Please can anyone help?! Many thanks Caroline Example: column 1 * * *column 2 * * *column 3 ABC * * * * * * complete * * *1a VTF * * * * * * incomplete * *1a VTF * * * * * * incomplete * *2- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problems with countif function | Excel Discussion (Misc queries) | |||
| Problems with COUNTIF formulae | Excel Discussion (Misc queries) | |||
| COUNTIF Problems | Excel Discussion (Misc queries) | |||
| problems with sumif and countif | Excel Discussion (Misc queries) | |||
| COUNTIF formula problems | Excel Discussion (Misc queries) | |||
Linear Mode
