| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i set up a complicated IF formula
I have a spreadsheet set up where column A has either Recall, Retail or VSR
in it, and column B has either Yes or No in it. I need to be able to count how many Recalls have yes beside them. Can anyone help? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i set up a complicated IF formula
Hi,
=SUMPRODUCT((A1:A20="Recall")*(B1:B20="Yes")) Mike "Scott" wrote: I have a spreadsheet set up where column A has either Recall, Retail or VSR in it, and column B has either Yes or No in it. I need to be able to count how many Recalls have yes beside them. Can anyone help? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i set up a complicated IF formula
Try this:
=SUMPRODUCT(--(A1:A100="Recall"),--(B1:B100="yes")) Adjust the ranges to suit your data. Hope this helps. Pete On Sep 24, 11:43*am, Scott wrote: I have a spreadsheet set up where column A has either Recall, Retail or VSR in it, and column B has either Yes or No in it. * I need to be able to count how many Recalls have yes beside them. Can anyone help? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i set up a complicated IF formula
Hmm,
After have bought E2007 I should get used to the new functionality so if you have e2007 try =COUNTIFS(A1:A20,"Recall",B1:B20,"Yes") Mike "Mike H" wrote: Hi, =SUMPRODUCT((A1:A20="Recall")*(B1:B20="Yes")) Mike "Scott" wrote: I have a spreadsheet set up where column A has either Recall, Retail or VSR in it, and column B has either Yes or No in it. I need to be able to count how many Recalls have yes beside them. Can anyone help? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i set up a complicated IF formula
Brilliant, thanks Mike
"Mike H" wrote: Hmm, After have bought E2007 I should get used to the new functionality so if you have e2007 try =COUNTIFS(A1:A20,"Recall",B1:B20,"Yes") Mike "Mike H" wrote: Hi, =SUMPRODUCT((A1:A20="Recall")*(B1:B20="Yes")) Mike "Scott" wrote: I have a spreadsheet set up where column A has either Recall, Retail or VSR in it, and column B has either Yes or No in it. I need to be able to count how many Recalls have yes beside them. Can anyone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Complicated Formula | Excel Discussion (Misc queries) | |||
| Complicated Formula | Excel Worksheet Functions | |||
| Complicated formula? | Excel Discussion (Misc queries) | |||
| Need help doing complicated formula | Excel Worksheet Functions | |||
| Complicated IF Formula | Excel Worksheet Functions | |||
Linear Mode
