Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif for multiple columns
I am looking for a countif formula to be setup so it will check 2 columns and
do a running count of two conditions. I want it to count if 1 column has something in it and the second column needs to have a specific content. Ie. Working on inventory chart that will need to have something in the 'description' field and then in the 'site' field the person will put the site in there. I am working on a summary chart that will have it be count how many times that there is something in the description field and Site 1 in the site field. Then I will have another line that will be count how many times that there is something in the description field and Site 2 in the site field |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif for multiple columns
Perhaps,
=SUMPRODUCT((A1:A10<"")*(B1:B10="Site 1")) Mike "Chart_Maker_Wonderer" wrote: I am looking for a countif formula to be setup so it will check 2 columns and do a running count of two conditions. I want it to count if 1 column has something in it and the second column needs to have a specific content. Ie. Working on inventory chart that will need to have something in the 'description' field and then in the 'site' field the person will put the site in there. I am working on a summary chart that will have it be count how many times that there is something in the description field and Site 1 in the site field. Then I will have another line that will be count how many times that there is something in the description field and Site 2 in the site field |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif for multiple columns
=SUMPRODUCT(--(A2:A100<""),--(B2:B100="specific"))
will count where A2:A100 is not empty AND B2:B100 is specific replace with the right columns and right criteria best would be to use a cell as criteria in column 2 B1:B100=C1 and put the criteria in C1 Peo Sjoblom "Chart_Maker_Wonderer" wrote in message ... I am looking for a countif formula to be setup so it will check 2 columns and do a running count of two conditions. I want it to count if 1 column has something in it and the second column needs to have a specific content. Ie. Working on inventory chart that will need to have something in the 'description' field and then in the 'site' field the person will put the site in there. I am working on a summary chart that will have it be count how many times that there is something in the description field and Site 1 in the site field. Then I will have another line that will be count how many times that there is something in the description field and Site 2 in the site field |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CountIf for multiple columns | Excel Discussion (Misc queries) | |||
Countif Using Multiple Columns | Excel Worksheet Functions | |||
Sum or Countif over Multiple Columns | Excel Worksheet Functions | |||
using a countif with multiple columns | Excel Worksheet Functions | |||
Using Countif on multiple columns | Excel Worksheet Functions |