LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,069
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 12:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"