Here's another one...
A1 = 897
=SUMIF(B4:INDEX(B:B,A1),"CD*",P4:INDEX(P:P,A1))
Here's another one...
A1 = 897
=SUMIF(B4:INDEX(B:B,A1),"CD*",P4:INDEX(P:P,A1))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks