| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
comparing two colums ? countif
Hi,
I have a spreadsheet with "weeks in column A and "Daily Charges" in column R. [see below] col A col R Week 1 Week 1 20 Week 1 week 2 week 2 How do I say calculate how many charges [col R] occur in "week 1" i.e. no of times there is a value in "col R" for week 1. What would I use if the no. of rows is 250 or if it varies month on month. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| countif with AND comparing 3 columns | Excel Worksheet Functions | |||
| countif comparing two columns | Excel Worksheet Functions | |||
| COUNTIF/SUMIF comparing two rows of data | Excel Worksheet Functions | |||
| COUNTIF function query for multiple colums | Excel Worksheet Functions | |||
| sumif/countif on non-consecutive colums - array? | Excel Worksheet Functions | |||
Threaded Mode
