Counting data in multiple columns

datadummy

Active Member
Joined
Mar 16, 2017
Messages
312
Office Version
  1. 365
Platform
  1. Windows
I am trying to count data that is in multiple columns and am getting an error, what I need to accomplish is counting if column A has a date entered that is in July (7/xx/2019) and then count if column I and J has a reading that is greater then .5.
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
A couple of questions. Where should the result be published? Is it column I and column J both have a value greater than .5 or is it an either/or situation. Is the count cumulative for the column(s). Suggest you tell us the whole story. Not enough information to even attempt a solution.
 
Upvote 0
My formula is on tab 2 and I have data entered on tab1 in column A that is a date for this instance July then I have data entered in columns I and J that can range from .1-1 and as long as the data point meets the previously stated criteria greater then .5 and is in the specified month for this instance July it should be counted, in the event the data point in columns I and J are below .5 or a date not July then it shouldn't be counted.
 
Upvote 0
You have failed to answer my questions. Please try again and look at each question and respond accordingly. It may be clear to you but I cannot read your mind or see your workbook.
 
Upvote 0

Forum statistics

Threads
1,214,520
Messages
6,120,011
Members
448,935
Latest member
ijat

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top