Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help please
HI, HELP REQUIRED WITH FORMULA FOR EXCEL PLEASE
Q: EXCEL WORKBOOK WITH TWO SHEETS, ONE TITLED MON & THE OTHER STAT. ON SHEET MON, I HAVE TWO COLUMNS (H, K) WITH A RANGE OF SAY 20 LINES EACH. ON SHEET STAT, I HAVE TWO CELLS (B5, F5) ON A LINE. I WANT €˜MON €˜H TO COMPARE WITH €˜STAT €˜B5. ON €˜H LINES THAT MATCH WITH €˜B5, IF A NUMBER IS ENTERED IN THE CORRESPONDING €˜MON €˜K LINE, €˜STAT €˜F5 WILL COUNT IT. EXAMPLE: €˜STAT B5 = MM €˜MON H8 & H12 = MM €˜MON K8 = 0800 & K12=ANYTHING BUT A NUMBER RESULT ON €˜STAT F5 SHOULD BE €˜1 THANKS! JOHN |