| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a Count formula
Current formula is: =COUNTIF(M8:M145,"WV")
From that info, I want to count the data from another column (X) that coincides with the "WV" data that I just collected. X column contains an IF formula: =IF((C145$a$1),0,1) ... [from cell 8:145] What would my formula be? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Creating a Count formula
=SUMIF(M8:M145,"WV",X8:X145)
-- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Shelyna" wrote in message ... Current formula is: =COUNTIF(M8:M145,"WV") From that info, I want to count the data from another column (X) that coincides with the "WV" data that I just collected. X column contains an IF formula: =IF((C145$a$1),0,1) ... [from cell 8:145] What would my formula be? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help creating formula | Excel Worksheet Functions | |||
| Formula format for Count or Countif funtion with two criterias | Excel Worksheet Functions | |||
| More Help Needed with Count formula | Excel Worksheet Functions | |||
| Group by count formula | Excel Worksheet Functions | |||
| Count If Formula | Excel Worksheet Functions | |||
Linear Mode
