Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
1 col has cells w/an H or C, tally cells for Hs and cells for Cs
a col. has either an H or C in the cells. The corresponding rows have
numeric values in each cell. How do I tally the value for the numbers with H and the value for cells with a C in the column (H and C are in a column to the left of the numberic rows for cells). |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
1 col has cells w/an H or C, tally cells for Hs and cells for Cs
Tink, try this, with h or c in column A and numbers in column B
=SUMIF(A1:A10,"H",B1:B10) =SUMIF(A1:A10,"C",B1:B10) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Tink" wrote in message ... a col. has either an H or C in the cells. The corresponding rows have numeric values in each cell. How do I tally the value for the numbers with H and the value for cells with a C in the column (H and C are in a column to the left of the numberic rows for cells). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you tally cells by their fill color? | Excel Discussion (Misc queries) | |||
By selecting cells adjacent to cells tally sheet | Excel Worksheet Functions | |||
tally of nonblank cells | Excel Worksheet Functions | |||
How Excel 2003 Highlight random cells and running tally appear? | Excel Discussion (Misc queries) | |||
Tally chart cells exist in Excel!?? | Charts and Charting in Excel |