| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum Data if Column B = Q
I wish to sum all data in Sheet2 Column J, if the value in Sheet2
Column B = The value in Sheet1 Column A I've tried =SUMPRODUCT(PC_Month_Locations=A8,PC_Month) Named Ranges above used instead of absolute references |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Plotting multiple Y column data versus single X column in Excel 20 | Charts and Charting in Excel | |||
| How do I sort data in column B to align with data in column A? | New Users to Excel | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
| counting data in one column and match with data in another column | Excel Discussion (Misc queries) | |||
| Matching one column against another column of data to show the same amount of data. | Excel Worksheet Functions | |||
Threaded Mode
