| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i sum if in two different cell references - Excel
Hi, Im trying to write "sumif" or "countif" formula to count when it sees
"apples" in one column and "red" in the other, anyone help? I have tried the following but it just says "0" (zero) COUNT(IF(A2:A6="APPLES",IF(B1:B6="RED",0))) A B APPLES RED APPLES GREEN APPLES GREEN APPLES RED APPLES RED APPLES RED APPLES RED |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to rename references from range names to cell references | Excel Discussion (Misc queries) | |||
| Excel Cell References are different to normal | Excel Worksheet Functions | |||
| COPY CELL WITH FILE REFERENCES IN EXCEL | Excel Discussion (Misc queries) | |||
| can you use cell references from Microsoft spreadsheet in excel ch | Excel Worksheet Functions | |||
| Excel change SUM references if you cut & paste the first cell in SUM... | Excel Discussion (Misc queries) | |||
Threaded Mode
