Ongoing Comparison - Amounts $

Nic_1990

New Member
Joined
Aug 11, 2009
Messages
3
Hi,

I currently use a formula =IF(G4<='Date Range'!C5,((COUNTIF(Deletes!A:A, 'Ongoing Call Comparison'!G4))),0) - Things to note: Deletes, Ongoing Call Comparison are worksheets in the same book. The cell reference G4 refers to a date that is auto-populated using the offset formula.

Effectively, it provides me a running tally of our figures for the month.

I now want to do the same, but with amounts $.

I know i need to the write the IF formula, that if the date ranges are the same then count, but i can't get it to work with an IF, then IF, then COUNT formula.

Should probably clarify what i'm after: If Date Range equals to the Offset Date, and the Offset date is equal to the date on the given worksheet, then count the dollar amounts.
Can anyone help.
Apologies for what may be a complicated question.

Thanks,
 
Last edited:

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
47,926
Office Version
  1. 365
Platform
  1. Windows
Nic

You've had at least 14 people look at this with no resposes. That would generally mean that you question is not understood. Some small amounts of sample data from the various sheets and the corresponding expected result(s) should help clarify what you have and what you want. Perhaps you could post some with Excel jeanie or RichardSchollar’s beta HTML Maker
 

Watch MrExcel Video

Forum statistics

Threads
1,122,469
Messages
5,596,315
Members
414,053
Latest member
Dual Showman

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
Top