| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF with criteria in 2 columns
=SUMIF(B$5:B$317,"Jones",C$5:C$317)
-- --- HTH Bob (change the xxxx to gmail if mailing direct) "EJ" wrote in message ... Ignore me.... I've worked it out with SUMPRODUCT! What I do need to know is a similar thing. I've been using =SUMIF(C$5:C$317,"0.5") - column C can contain any value between 1 and 50 and I need the sum, but I only need it to use this if cells in column B meet a particular criteria, as per my previous question. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sum items in a column based on criteria located in other columns | Excel Discussion (Misc queries) | |||
| countif = < AND value in adjacent columns match criteria | Excel Worksheet Functions | |||
| Excel COUNTIF Function - a range as criteria ? | Excel Worksheet Functions | |||
| countif criteria only one word of few doesn't work | Excel Worksheet Functions | |||
| want to count in two columns; countif (colA=x AND colB=y)? | Excel Worksheet Functions | |||
Threaded Mode
