In Column A I have letters:
Column A
M
OM
P
C
OP
OC
In Column P I have amount of hours:
Column P
500
200
Not all cells in P have a value.. what I want to do is lookup in column A9:A36 if there is an "M" to total all hours in cell P9:P36 that have an M...
I thought =IF(A9:A36="M", Sum(P9:P36)) or something to that.. but I cant get any formula to work...
Any ideas? I thought this would be easier....
Sumif
=sumif(a9:a36,"m",p9:p36)
Hi,
Try
=SUMIF(A9:A36,"*M*",P9:P36)
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Andy's formula of you want to test for an "M" on it's own, and mine if you want an "M" anywhere in the cell.
Oh Thank you, Thank you, Thank you!!!!!!!!!! You have saved me so much time! I love this site!
You are the best!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks