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). |
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). |
All times are GMT +1. The time now is 05:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com