using countif and
I have a large database containing several columns of information such as
store number, store area and general ledger account number. I'd like to come up with a formula on a new Excel sheet where I can count the number of stores that meet a certain critera....For example...I'd like for it to count the number of stores in area 11 that are also in GL account 01-101. How can I create a formula that will count this information only if the data meets the critera I need? I've tried Countif(Column of Area data,"=11")and(countif(column of GL data, "=01-101")), however I keep getting an error and can't seem to come up with the right way to do this. |
See
http://xldynamic.com/source/xld.SUMPRODUCT.html Regards, Peo Sjoblom "Brian" wrote: I have a large database containing several columns of information such as store number, store area and general ledger account number. I'd like to come up with a formula on a new Excel sheet where I can count the number of stores that meet a certain critera....For example...I'd like for it to count the number of stores in area 11 that are also in GL account 01-101. How can I create a formula that will count this information only if the data meets the critera I need? I've tried Countif(Column of Area data,"=11")and(countif(column of GL data, "=01-101")), however I keep getting an error and can't seem to come up with the right way to do this. |
All times are GMT +1. The time now is 07:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com