LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
crafty_girl
 
Posts: n/a
Default countif = < AND value in adjacent columns match criteria

Col D Col G Col H
-160 VALUE IPG
20 VOLUME TSG

Example:
I'm trying to count values in column D that are greater than 10 and less
than 20 IF column G = VALUE AND column H = IPG. I have been struggling with
this since yesterday and just can't get it right. Does anyone know how to
write the formula so it will work?

Thanks!
 
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:12 AM.

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

About Us

"It's about Microsoft Excel"