Thread
:
SUMIF Function
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
SUMIF Function
Try:
=SUMPRODUCT(((ISNUMBER(FIND("000",A1:A4)))*B1:B4)-((ISNUMBER(FIND("50",A1:A4)))*B1:B4))
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Manos" wrote in message
...
Dear all
I have to add and subtract the values of some cells.So that's the case
In the first column i have the codes of account which have in the first
part
4 numbers underscore and some other figures. (1000_A1, 1000_A2, 1050_A3,
2000_A4).
So based on the first four numbers i want to add those that have 000 and
subtract those that include 50 (eg lets say that the third character to be
5
and the fourth characted to be zero).
So i need to add 1000_a1 + 1000_a2 + 2000_a4
and sub tract the 1050_a3
I thouhg to use one sumif to add those include 000 and another one to
sumif
with 50.The problem is that i do not know how to set up the if match in
SUMIF.
Any suggestions?
Thanks in advance
Manos
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann