Hi Bonnie,
This is definitely a job for the SUMPRODUCT function, which is a wizz at doing
just what you are asking about.
If you post a sample of your data, there would be many is this group that could
help you with it.
Regards - Dave.
> Date: Thu, 5 Nov 2009 11:36:35 -0800
> Subject: $$Excel-Macros$$ COUNTIF Formula Help
> From: bonnie.m.r...@usace.army.mil
> To: excel-macros@googlegroups.com
>
>
> I have acomplex formula I need to plug into an Excel spreadsheet and I
> can't figure out how to get the results I need. Can anyone provide me
> assistance please?
>
> Here's what I have:
>
> Column D = date of payment
> Column E = amount of payment
> Column I = category (A, C, F, M, N, D)
> Columns J, K, L, M (these break down the categories)
>
> I need to add up the number of each category and sub-category (i.e., A
> +J, or A+K, or A+L, or A+M, or C+J, or C+K, or C+L, and so on) and
> place the individual totals in separate cells.
>
> I also need to add up, by the respective sub-categories (above), the
> dollar value of only those amounts in Column E which reflect a date of
> payment in Column D. (Column D may have dollar amounts in other cells
> which do not reflect a date in Column E.)
>
> To add to this, I need to perpetuate these formulas to include the
> entire columns as they grow with additional data being added daily.
> I'm thinking this would be reflected as, for example, E:E rather than
> E4:E200 (or whatever).
>
> I know the basics of Excel, but this is beyond my knowledge. I would
> appreciate any assistance in creating the formulas I need; or even a
> guide (nudge) in the right direction. Thank you, in advance, for any
> assistance you can provide.
>
> >
_________________________________________________________________
Want to know what your boss is paid? Check out The Great Australian Pay Check
now
http://clk.atdmt.com/NMN/go/157639755/direct/01/
--~--~---------~--~----~------------~-------~--~----~
----------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
-~----------~----~----~----~------~----~------~--~---
