Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am using Excel 2003 and am really stuck on getting a sum or count function
to work if it matches another column. I know this might be bread and butter to some of you but as a bit of a novice, I've tried what I consider to be the obvious and get nothing. My problem - On a sheet B I want to sum (or count) all the times "Telephone" occurs in columns F or G only if "Other" occurs in columns K or L, these columns being on sheet A. See, told you it was simple enough ... but please Please PLEASE how do I do it? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003: Count total days elapsed | Excel Worksheet Functions | |||
Excel 2003 - Count dates | Excel Discussion (Misc queries) | |||
Excel 2003 Count entries by months | Excel Discussion (Misc queries) | |||
Excel 2003 List with Frequency Count | Excel Discussion (Misc queries) | |||
Count widgets between two dates - Excel 2003 | Excel Discussion (Misc queries) |