EXCEL

D

Donna

I am trying to set up a formula with two conditions. I want my data to be if there is info in column A=A name, and if in column B=>270, then I want to sum column C
 
F

Frank Kabel

Hi
try
=SUMPRODUCT(--(A1:A100="name"),--(B1:B100>=270),C1:C100)

--
Regards
Frank Kabel
Frankfurt, Germany

Donna said:
I am trying to set up a formula with two conditions. I want my data
Click to expand...
to be if there is info in column A=A name, and if in column B=>270,
then I want to sum column C
 

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

Autonumber field in Excel that behaves the same as Access 0
Consolidation Table from Different Excel Tabs with Different Format 1
Sum of values in column A based on 0/1 of column B 2
Mail Merge Directory Conditional Page Break 0
Copy addition formula of non-consecutive horizontal cells 2
MS Project Center-Autolink column fields 0
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Two columns followed by single page-width column on same page 0

Top