| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
=SUMPRODUCT(--(A2:A100="Supplier"),--(D2
 100="E"))"ka7djw" wrote: > Ok lets make my question more clear.. > > In column "A" I have Supplier, or CFAC, or EM&T. In Column "D", I have any > letter A through Z and any number 1 through 9. > > If I want to count everything = to "Supplier" in column A that have and "E" > in in coulmn D, how do I write the formula. > > I am adding this to an existing spreadsheet that a lot of people change > things in and I want the count for the bar chart to be automatic...ie., when > an "E" in column D changes to an "A" it will subtract from the total of "E"'s > and add to the total of the "A"'s... > > Thanks |
|
|
|
|
|||
|
Guest
Posts: n/a
|
try this
=SUM(IF((A1:A100="Supplier")*(D1 100="E"),1))ctrl>shift>enter (not just enter) "ka7djw" wrote: > Ok lets make my question more clear.. > > In column "A" I have Supplier, or CFAC, or EM&T. In Column "D", I have any > letter A through Z and any number 1 through 9. > > If I want to count everything = to "Supplier" in column A that have and "E" > in in coulmn D, how do I write the formula. > > I am adding this to an existing spreadsheet that a lot of people change > things in and I want the count for the bar chart to be automatic...ie., when > an "E" in column D changes to an "A" it will subtract from the total of "E"'s > and add to the total of the "A"'s... > > Thanks |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| formula to do a count for info in another column | mike | Microsoft Excel Misc | 3 | 24th Dec 2008 07:00 PM |
| How to update column info based on column info from another worksh | Hummingbird | Microsoft Excel Misc | 3 | 29th Jul 2008 09:54 PM |
| Referencing date column A & time column B to get info from column | TVGuy29 | Microsoft Excel Misc | 1 | 24th Jan 2008 09:50 PM |
| Link info in one cell to info in several cells in another column (like a database) | hansdiddy | Microsoft Excel Misc | 1 | 22nd Feb 2006 02:27 AM |
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Sam via OfficeKB.com | Microsoft Excel Worksheet Functions | 9 | 31st Jul 2005 03:37 AM |
