SUMIF Problem

A

andyp161

Hi there,

I would like to extend the SUMIF function so that if criteria are me
in column A and column B, then the values in column C are summe
together i.e. if cells in the array A1:A30 contain "Andrew Penfold" an
if the adjacent cells in the array B1:B30 contain a value >0, then
want the values in the adjacent cells in the array C1:C30 to be summe
together. Is this possible??

Many thanks

And
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF with criteria "<>" & "=" 4
sumif function leaving a blank cell when criteria not met 3
Problem with SUMIF Formula 3
SumIf equation question 6
summing adjacent data in a worksheet 3
Rounding Error when Calculating similar times 3
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
VBA Coding Help for Beginner 0

Top