| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count or Sumif formula
How would I write a formula for the example below
a b 1 m scaf 2 b scaf 3 b scaf 4 b lab I am wanting to create a count if to where I am counting the b's in a that have scaf. The answer should be 2. Thank you Jeremy |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count or Sumif formula
Try this =SUMPRODUCT(--(A1:A4="b"),--(B1:B4="scarf"))
On Jun 10, 10:41 am, Jeremy wrote: How would I write a formula for the example below a b 1 m scaf 2 b scaf 3 b scaf 4 b lab I am wanting to create a count if to where I am counting the b's in a that have scaf. The answer should be 2. Thank you Jeremy |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count or Sumif formula
=SUMPRODUCT(--(A2:A10="b"),--(B2:B10="scaf"))
-- Regards, Peo Sjoblom "Jeremy" wrote in message ... How would I write a formula for the example below a b 1 m scaf 2 b scaf 3 b scaf 4 b lab I am wanting to create a count if to where I am counting the b's in a that have scaf. The answer should be 2. Thank you Jeremy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Complex SUMIF/COUNT IF | Excel Discussion (Misc queries) | |||
| How to Count the number of "rows" (or Array items) included in a Sumif formula? | Excel Discussion (Misc queries) | |||
| Count, Countif, Sumif?? | Excel Worksheet Functions | |||
| sumif or count between zero and 3 | Excel Worksheet Functions | |||
| sumif or count between zero and 3 | Excel Worksheet Functions | |||
Linear Mode
