Conditional Sums
Hmmmmmmm
Thanks Ron but there appears to be something funny going on......
I tried your revised formulae but, the moment I hit enter, =SUMIF(E2:D30
changes to =SUMIF(D2:E30.
I've tried entering the date manually and copying & pasting your
formulae, but it changes every time.
Any ideas?
Regards
Peter
-----Original Message-----
From: Ron Coderre ]
Posted At: 16 February 2007 18:01
Posted To: microsoft.public.excel.newusers
Conversation: Conditional Sums
Subject: Conditional Sums
Darn! I reversed the ranges.....
The formula should be:
D31: =SUMIF(E2:D30,"S",D2:D30)
D32: =SUMIF(E2:D30,"M",D2:D30)
D33: =SUMIF(E2:D30,"P",D2:D30)
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"Peter J Elliott" wrote:
I have a table containing numerical values in column D and text in
column E.
The text in column E can be either S, M or P
In cell D31 I want to total the values in column D corresponding to
the letter S in column E In cell D32 I want to total the values in
column D corresponding to the letter M in column E In cell D33 I want
to total the values in column D corresponding to the letter P in
column E
I've tried using COUNTIF and the Conditional Sum Wizard, but I can't
get something that does the job.
Could someone please suggest a formula to do the job?
Many thanks
Regards
Peter
|