Using criteria from one formula output to feed another?

[2weetabix]

Hi All,

I've been banging my head against a brick wall on this all day and can't fathom if its possible.
I've got a spreadsheet two two tabs.
One table contains columns of data. Column C is IP addresses, column F is numbers.
I've written this simple formula to search column C for anything with the IP address of 192.168 and return the sum of the corresponding values found in column F, which works fine.
=SUMIF(vDatastore!C:C,"*192.168.*",vDatastore!F:F)

However I wish to build on this and report only the largest value reported in column F from this criteria.

Is this possible?

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[2weetabix]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Office 365

 

[Fluff]

In that case how about

=MAXIFS(vDatastore!F:F,vDatastore!C:C,"*192.168.*")

 

[2weetabix]

In that case how about

=MAXIFS(vDatastore!F:F,vDatastore!C:C,"*192.168.*")

This is why i love this forum - works perfectly - many thanks

 

[Fluff]

You're welcome & thanks for the feedback.