| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if a:a (range) equals january and c:c equals gas then add g:g ($)
a:a has is a range of monthly purchases and c:c is which month purchased. I
would like on a different sheet to calculate only those gas purchases in january (automatically). I tried this but did not succeed: =IF(AND(Transactions!A:A=A:A,Transactions!C:C="gas oline"),SUM(Transactions!G:G),0) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Define range for graphs/charts with validation list | Excel Discussion (Misc queries) | |||
| If statement where the logical test is a range that equals a word | Excel Worksheet Functions | |||
| Help! Selecting data according to date range | Excel Discussion (Misc queries) | |||
| Sm Product a Calendar Month Range? | Excel Worksheet Functions | |||
| Basic: Looking up Data in Range | Excel Discussion (Misc queries) | |||
Threaded Mode
