Sum if adjacent cell is not empty

[Paklr]

Hi, my problem is: I have a table with values in a sheet called "Hist", imagine this:

Michael Hepburn		90
Michael Hepburn	Team A	50
Michael Hepburn	Team A	10
Andrey Zeits	Team B	40

<tbody>
</tbody>

And in another sheet caled "Classification" I have in A2 "Michael Hepburn", and I'd like to have in B2 the sum of all Michael Hepburn values in "Hist" when the cell next to it is not blank. In this case, the result of that sum would be 50 + 10 = 60.

 

[pgc01]

Hi

Assuming the data in Hist!A:C, Try:

=SUMIFS(Hist!C2:C5,Hist!A2:A5,"Michael Hepburn",Hist!B2:B5,"?*")

 

[ddarko77]

Hi

Assuming the data in Hist!A:C, Try:

=SUMIFS(Hist!C2:C5,Hist!A2:A5,"Michael Hepburn",Hist!B2:B5,"?*")

Hey, thanks for posting this, quick question, what does the ?* mean? Cheers

 

[pgc01]

... what does the ?* mean?

Hi

"?" is a wildcard for any 1 character. "*" is the wildcard for "any sequence of characters".

This means that "?*" stands for "at least 1 character".

 

[ddarko77]

Hi

"?" is a wildcard for any 1 character. "*" is the wildcard for "any sequence of characters".

This means that "?*" stands for "at least 1 character".

Aha! thanks.. good tip for me to use.. thanks again