HELLO and HELP

  • Thread starter Thread starter jtees4
  • Start date Start date
J

jtees4

I am trying to help my wife at work. I have used Excel in the past,
but not for awhile....and frankly I was never very good at it.

I figured out that this formula solved her first problem....works
perfectly:
=SUMPRODUCT((A5="MEDICARE")*(H5>0))
One down one to go....and I'm stuck.

Now the second problem is this:
I need similar info, but with an added layer I guess....I only know
layman's terms ;-)
I need
IF A5="MEDICARE" AND H5>0 then I need it to total another column, call
it H5:H100

I hope this makes sense and thanks for any help!!!!!




*************
Some of my music:
http://www.soundclick.com/bands/default.cfm?bandID=789610
 
Hi,

Am Mon, 26 May 2014 10:45:30 -0400 schrieb jtees4:
I am trying to help my wife at work. I have used Excel in the past,
but not for awhile....and frankly I was never very good at it.

I figured out that this formula solved her first problem....works
perfectly:
=SUMPRODUCT((A5="MEDICARE")*(H5>0))
One down one to go....and I'm stuck.

Now the second problem is this:
I need similar info, but with an added layer I guess....I only know
layman's terms ;-)
I need
IF A5="MEDICARE" AND H5>0 then I need it to total another column, call
it H5:H100
Click to expand...

I don't know if I understood your problem.
But try:
=SUMIF(A5:A100,"MEDICARE",H5:H100)


Regards
Claus B.
 
Hi,

Am Mon, 26 May 2014 10:45:30 -0400 schrieb jtees4:


I don't know if I understood your problem.
But try:
=SUMIF(A5:A100,"MEDICARE",H5:H100)


Regards
Claus B.
Click to expand...

Thanks for the quick response! I misstated the columns I needed.
I need:
IF A5="MEDICARE" AND
IF H5 has any number in it (I used >0)
Then I need ANOTHER column totaled, say column E

I hope that time I got it right!!!! A little tired this morning.





*************
Some of my music:
http://www.soundclick.com/bands/default.cfm?bandID=789610
 
Hi,

Am Mon, 26 May 2014 11:04:18 -0400 schrieb jtees4:
IF A5="MEDICARE" AND
IF H5 has any number in it (I used >0)
Then I need ANOTHER column totaled, say column E
Click to expand...

if you want to sum column E if in the same row in column A is
"MEDICARE" and in column H a number > 0 then try:

=SUMIFS(E5:E100,A5:A100,"MEDICARE",H5:H100,">0")
or
=SUMPRODUCT(--(A5:A100="MEDICARE"),--(H5:H100>0),E5:E100)

If you want to sum E5:E100 if only A5 and H5 have the expected values
then try:
=IF(AND(A5="MEDICARE",H5>0),SUM(E5:E100),"")

Regards
Claus B.
 
Hi,

Am Mon, 26 May 2014 11:04:18 -0400 schrieb jtees4:


if you want to sum column E if in the same row in column A is
"MEDICARE" and in column H a number > 0 then try:

=SUMIFS(E5:E100,A5:A100,"MEDICARE",H5:H100,">0")
or
=SUMPRODUCT(--(A5:A100="MEDICARE"),--(H5:H100>0),E5:E100)

If you want to sum E5:E100 if only A5 and H5 have the expected values
then try:
=IF(AND(A5="MEDICARE",H5>0),SUM(E5:E100),"")

Regards
Claus B.
Click to expand...

Thank you! I can't try it right now but I will this afternoon and let
you know. Thanks so much.




*************
Some of my music:
http://www.soundclick.com/bands/default.cfm?bandID=789610
 
Hi,

Am Mon, 26 May 2014 11:04:18 -0400 schrieb jtees4:


if you want to sum column E if in the same row in column A is
"MEDICARE" and in column H a number > 0 then try:

=SUMIFS(E5:E100,A5:A100,"MEDICARE",H5:H100,">0")
or
=SUMPRODUCT(--(A5:A100="MEDICARE"),--(H5:H100>0),E5:E100)

If you want to sum E5:E100 if only A5 and H5 have the expected values
then try:
=IF(AND(A5="MEDICARE",H5>0),SUM(E5:E100),"")

Regards
Claus B.
Click to expand...



Claus, thanks again. This one worked like a charm:

=SUMPRODUCT(--(A5:A100="MEDICARE"),--(H5:H100>0),E5:E100)

Perfect. The "SUMIFS" may not have worked because I have an old
version of Excel at home.

I may post another problem tomorrow, at this point I am not sure
exactly what she needs.

Thank you!




*************
Some of my music:
http://www.soundclick.com/bands/default.cfm?bandID=789610
 
Back
Top