counting for a sum w/ multiple criteria

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michelle D - 13 Dec 2005 21:51 GMT

In an excel worksheet I am trying to get a formula to return a numeric value
for the following instance

Column c Column L

1/5/2006 QB

I need a formula that will count every time a row has these two criteria.
Any help would be appreciated

Reply to this Message

Doug Robbins - Word MVP - 14 Dec 2005 05:10 GMT

You should ask in an Excel newsgroup, but you need to set up an
If..then..else formula

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> In an excel worksheet I am trying to get a formula to return a numeric
> value
[quoted text clipped - 6 lines]
> I need a formula that will count every time a row has these two criteria.
> Any help would be appreciated

Reply to this Message

macropod - 14 Dec 2005 10:31 GMT

Hi Michelle,

Try:
=SUM(IF((C1:C100=DATEVALUE("1/5/2006"))*(L1:L100="QB"),1,))
entered as an array formula (i.e. press Ctrl-Shift-Enter, instead of just
enter). The formula will then show up as:
{=SUM(IF((C1:C100=DATEVALUE("1/5/2006"))*(L1:L100="QB"),1,))}

Adjust your range references to suit and, if the test date & string are in
cells, you can refer to them directly, as in:
=SUM(IF((C1:C100=A1)*(L1:L100=A2),1,))
substituting A1 & A2 for the actual references.

Cheers

> In an excel worksheet I am trying to get a formula to return a numeric value
> for the following instance
[quoted text clipped - 5 lines]
> I need a formula that will count every time a row has these two criteria.
> Any help would be appreciated

Reply to this Message