ExcelBanter - sumproduct or sumif function

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - sumproduct or sumif function (https://www.excelbanter.com/new-users-excel/228413-sumproduct-sumif-function.html)

Graham

sumproduct or sumif function

I have data in columns A:C and would like to sum (Add) the data in A if a
specific criteria in C is met...please assist with a formulae

A B C
100 ? wss
25 cx
50 wss
10 gh

I would like to add values in A were C =wss

Graham

sumproduct or sumif function

Hi Guys
I figured it out, =sumif($C$1:$C$4,"wss",A:A),thanx

"Graham" wrote:

I have data in columns A:C and would like to sum (Add) the data in A if a
specific criteria in C is met...please assist with a formulae

A B C
100 ? wss
25 cx
50 wss
10 gh

I would like to add values in A were C =wss

All times are GMT +1. The time now is 05:59 AM.