Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sum column A based on column B
I have 2 columns. Col A1:A15 has my data andd col B1:B15
has a letter A, B or C in the cells. I want my summary cell to sum only col A data when col B = A for the range. Thanks for your help. Dan col col A B 13 C 23 A 21 B 67 A 45 A etc summary cell =135 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
sum column A based on column B
Hi Dan
you can use SUMIF =SUMIF(B1:B15,"A",A1:A15) -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Dan" wrote in message ... I have 2 columns. Col A1:A15 has my data andd col B1:B15 has a letter A, B or C in the cells. I want my summary cell to sum only col A data when col B = A for the range. Thanks for your help. Dan col col A B 13 C 23 A 21 B 67 A 45 A etc summary cell =135 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Unique Values in 1 Column based on Date Range in another Column | Excel Worksheet Functions | |||
Count number of cells and total in one column, based on another column suffix | Excel Worksheet Functions | |||
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) | |||
move contents of column C based on criteria related to column A | Excel Discussion (Misc queries) | |||
macro to transpose cells in Column B based on unique values in Column A | Excel Programming |